Read a PostgreSQL EXPLAIN plan before adding an index
Find the expensive step and distinguish estimates from measurements.
PostgreSQL / SQL / Performance
TECHNOLOGY / KNOWLEDGE / PRACTICE
Search results: PostgreSQL
Practical guides to AI, Python, Git, SQL, Web/API, SAP/ERP and mathematical models, with explanations, code examples, sources and limitations.
Every word must appear in the article. Use quotes for an exact phrase.
Why SQL comparisons with NULL do not behave like zero
Understand IS NULL, three-valued logic and the difference between COUNT(*) and COUNT(column).
SQL / PostgreSQL / NULL