Postgres Slow Query on Indexed Column, Why
Having an index on a column doesn't guarantee PostgreSQL will actually use it, or that using it will make your query fast. When a query stays slow despite an...
Category
PostgreSQL
Fixing PostgreSQL errors, performance issues and configuration quirks.
Postgres UNION-Based Query Returning Unexpected Null Rows
When a UNION or UNION ALL query in PostgreSQL returns rows with unexpected NULL values in columns that clearly have data in the underlying tables, the cause is...