An easy to follow 50 minute talk from PostgresOpen Silicon Valley 2017 on different forms of concurrency and how Postgres works with them.

A simplified guide for what you should expect in terms of the read performance and ingest performance for queries in Postgres.

2Q PGConf is dedicated to exchanging & increasing knowledge about PostgreSQL. Join us for this unique opportunity taking place in NYC & Chicago to learn more about recent achievements and exciting future developments in PostgreSQL from world-class experts.

Users are automatically granted permissions due to their membership in a built-in role called PUBLIC.

Want to swap the order of a few columns without having to drop/remove or re-write the whole table? Part 2 here.

pgRouting is useful if you’re already using PostGIS. It can be handy for helping find various paths and routes between locations, here’s a primer on getting started with it.

cume_dist computes the %age of rows that are ‘less than or equal,’ while percent_rank computes those that are ‘less than’ the current row, except it also assumes the current row isn’t in the partition.

A golden oldie from last year that might be worth revisiting.

A look at Postgres 10’s logical replication and partitioning support, how it plays with pglogical, and how it’s still evolving.

Select for update is usually what you want when grabbing a value that you’re going to update right after, but here we see where using xmin could be a valid approach.

Get a Linode server up and running in seconds. Get a $20 credit on a new account.

Provides the tools needed to produce audit logs required to pass government, financial, or ISO certification audits.