Code-heavy slides from a talk given at FOSDEM PgDay that cover filters, BOOLEAN tests, XMLTABLE, and inverse distribution functions.

A collection of responses to the question: “Whats your favorite hidden gem of Postgres that you wish more people knew about?”

Happening April 16 - 20 at the Westin Jersey City Newport, we will be featuring two full days of Postgres training opportunities, three days of breakout session content, a large sponsor hall, numerous workshops, a job fair, and more. Register today.

We all love a good, thorough SQL tutorial, right? This is a great walkthrough of bringing together several SQL features in a relatively advanced way.

A quick intro to index scans in Postgres, highlighting what the optimizer does when a single query is processed.

Putting JSON into Postgres is pretty simple nowadays, but exporting it in elaborate ways can require a bit of work as in this example.

Want to contribute some code, a patch, even some documentation? Here’s a talk covering how to get involved. (See links to the slides and video at the bottom of the page.)

Citus is an extension for scaling Postgres horizontally.