PostgreSQL is the world’s most advanced open source object-relational database management system. It was developed by the PostgreSQL Global Development Group.

PostgreSQL's Hash Indexes Are Now Cool
September 26, 2017
*/ Since I just committed the last pending patch to improve hash indexes to PostgreSQL 11, and since most of the improvements to hash indexes were...
PL/Java Adoption
September 19, 2017
PL/Java has been around since 2005, but it has regularly struggled to gain users. Unfortunately, a lot of these problems are specific to the Java...
When to Use Server-Side Logic
September 12, 2017
The use of server-side logic, particularly stored procedures, has been a highly contentious topic among database professionals for decades. The...
Which NoSQL Database for New Project?
31 augustus 2017
Oh, how I love the title of this 2014 Slashdot request, "Which NoSQL Database For New Project?" The user already knows the type of clients (iPhones...
You Don't Need Every Feature of Your Previous Database
08 augustus 2017
In a March blog post I talked about the mismatch between what people expect from Postgres in terms of hints, and what exists. In this blog post I...
Outer Joins and Where Clauses
July 19, 2017
*/ Postgres supports both traditional join syntax , which uses the where clause to specify joined columns, and ansi join syntax, that uses the word...
Advanced Retention Management for Postgres Backups
June 21, 2017
Data retention has become a greater challenge for database administrators as volumes have exploded with new digital applications and data from mobile...
Allowing Only One Null
June 14, 2017
While the sql standard allows multiple nulls in a unique column, and that is how Postgres behaves, some database systems (e.g. ms sql ) allow only a...
ALTERing the Bounds of a Partition
June 12, 2017
PostgreSQL 10 is full with a lot of big, new and exciting features. Declarative partitioning is one of those. It is something users have wanted for...
Postgres Vision Training Day at MIT Ends with Certification
May 26, 2017
In a 2013 McKinsey & Company global survey , 35 percent of executives said improving the talent level and capabilities of IT staff was critical...

Get Postgres Tips and Tricks

Subscribe to our newsletter to get advanced Postgres how-tos.