Under the covers Postgres keeps a lot of stats about your data in order to better execute queries. Here’s the first part of a series that starts to tell you everything you could want to know about how it works.

When building complex SQL functions, ASSERT can be used to avoid undesirable states as well demonstrated here.

The Citus extension that helps scale out Postgres has a new release including tenant isolation for multi-tenant apps, new reference table APIs, view support for distributed tables, and distributed vacuum/analyze.

In this recording from VividCortex's live webinar, Baron Schwartz discusses some of the new features and capabilities available in MySQL 8.0 and PostgreSQL 9.6. Watch to learn how MySQL and PostgreSQL have changed with these most recent updates.

Want to learn how databases get tested and in particular Postgres? This talk from last year’s PGConf US digs in to the testing processes the Postgres project uses.

If you’ve ever had a case where a table was dropped and you want to find out what did it, this post looks at how to find the culprit transaction.

How to get Postgres to do the heavy lifting for you.

Using Google’s libphonenumber via pg_libphonenumber is one compelling option.

In this episode of our Metrics Maven series our data scientist shows how to calculate weighted moving average.

Postgres has \copy support for loading CSVs and other files into Postgres. This tool goes one step further and simplifies the process, even taking care of creating the tables for you.