Primary Keys vs. UNIQUE Constraints in PostgreSQL
What primary keys and UNIQUE constraints do: Both features create an index, but what makes a primary key different from a unique constraint?
Building an Oracle to PostgreSQL migrator: Lessons learned
Oracle to PostgreSQL migration - Lessons learned in building a migration tool. How to avoid errors, null bytes and broken content.
PostgreSQL: Create indexes after bulk loading
This post describes when to create indexes, before or after bulk loading of the data. Improve your PostgreSQL performance by doing it right.
PostgreSQL: The power of a SINGLE missing index
This poem post shows the importance of even one missing index for a target PostgreSQL table from a performance perspective.
Fixing out-of-sync sequences in PostgreSQL
This post shows how to deal with out of sync PostgreSQL sequences in underlying tables using open-source pg_sequence_fixer extension
PostgreSQL grouping sets: ROLLUP & CUBE
PostgreSQL offers many OLAP-style workload features. One of those features is called “GROUPING SETS”. Let's deep dive into ROLLUP & CUBE:
PostgreSQL Security: 12 rules for database hardening
UPDATED August 2023: PostgreSQL security - make your database safe. Follow these 12 recommendations for proactive database hardening.
PostgreSQL zheap: Current status
zheap has been designed as a new storage engine to handle UPDATE in PostgreSQL more efficiently. Read about the current status and more.
PostgreSQL: LIMIT vs FETCH FIRST ROWS ... WITH TIES
The LIMIT/OFFSET clause is off standard and thus not portable. Read about the proper way to handle it by using “SELECT … FETCH FIRST ROWS”.
Understanding LATERAL joins in PostgreSQL
LATERAL joins are extremely useful & can be utilized in many cases to speed up operations, or to simply make code a lot easier to understand.
