I have a db of city geocode value like lat: 55.8652, lon: -4.2514. When I run the SQL on Supabase SQL Editor, then I get the values that I want. SELECT * FROM education WHERE ST_Distance (education.loc, ST_SetSRID (ST_MakePoint (…
To my amazement, I noticed that simple text search APIs don't utilize the indexes on tables that are part of an RLS policy.For example, mytable has a policy on it, and I'm using a column called text_vector to search on:…
I have a Postgresql server (Windows) that is supposed to ONLY accept SSL connections, but it doesn't. This is the configuration of my pg_hba.conf file: # IPv4 local connections: hostssl all all 0.0.0.0/0 md5 This is the SSL part of…
I'm trying to use Ansible to create a PostgreSQL database user, but I'm encountering the following error: TASK [Create db user] ********************************************************************** fatal: [test]: FAILED! => {"changed": false, "msg": "unable to connect to database: connection to server on socket "/var/run/postgresql/.s.PGSQL.5432"…
I have a table where we have partners and orders are set. |partner_id|order_id| | -------- | ------ | |1 |5 | |1 |6 | |2 |7 | |4 |8 | |4 |9 | |4 |10 | Here we have a…
My objective is to make Postgres choose a faster plan after a large table update. Before the table update, the plan PG choose is what I expect (the faster plan). However, after the update, PG chooses a slower plan (it…
Hi i was reading postgres indexes, trying find a solution to make gin operator work with like on array. Let me explain. I have a need to find a range of unique keys. This is not that simple, because i…
I'm trying to create a django query that compares my models created_at date to see if they are at least x hours old where x is defined in a nested JsonField hours_old. So for example: # This creates a timedelta…
I have a problem with my request. I have a table where the id is UUID and I have a query like SELECT * FROM table WHERE fk = ? ORDER BY id ASC LIMIT 5 and this query runs…
I have a table like this in Postgres: user_id project status 1 p1 finished 2 p1 finished 2 p2 finished 2 p3 finished 3 p1 finished 3 p2 finished 3 p3 finished 4 p1 finished 5 p1 finished 6 p1…