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: Database
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
How BEGIN, COMMIT, and ROLLBACK Combine Multiple Changes into a Single Operation in PostgreSQL
Transactions in PostgreSQL allow grouping SQL operations into atomic blocks using the commands BEGIN, COMMIT, and ROLLBACK. This ensures data integrity: either all changes are applied or none at all. The mechanism is based on ACID principles - atomicity, consistency, isolation, and durability.
PostgreSQL / transactions / BEGIN / COMMIT / ROLLBACK / ACID / savepoint
SQL: WHERE vs HAVING - Difference in Row and Group Filtering
A detailed technical breakdown of the differences between WHERE and HAVING clauses, focusing on execution order, aggregate function compatibility, and performance optimization strategies.
SQL / PostgreSQL / Database / Query Optimization / Data Analysis