TPC is a common benchmark for database performance. Here’s a look at how Postgres measures up, with in some cases a nice 5x performance gain.

Postgres keeps a lot about performance under the covers, here’s a great dive into whats there and how to begin to take advantage of it.

Postgres has an index type for just about everything you could want. Here’s a great overview of types available and guidance around them.

Learn how to use Postgres Enterprise Manager to effectively monitor and manage your Postgres database servers in this free, 4-hour online training session on Tuesday, May 10, 2016. Hurry - seats fill up fast!

As highlighted in this issue, Postgres has a number of useful index types already, but that doesn’t mean we can’t use more. Bloom indexes are the latest to be added coming in 9.6 and in certain cases with indexing multiple columns can be incredibly handy.

Citus, the extension that allows you to easily shard your data turning Postgres into a horizontally scalable distributed database, went open source a few weeks ago, so now it’s available for anyone to use. This week brings Citus Cloud, an as-a-service offering making it simple to put in production and not have to manage yourself.

Pg_paxos is a database-level implementation of the widely renowned Paxos protocol. The defining feature of pg_paxos is that replication across the nodes of the cluster is always conflict-free. This in turn leads to a strictly consistent (as in the distributed sense of the C in CAP) view of the cluster.

Row level security, which landed in Postgres 9.5, allows you to not just secure an entire table, but specific rows within it. If you have some more specialized or stricter security needs of your database it may be part of the solution.

Postgres under the covers is essentially an append-only log. This means it periodically needs to go in and clean up unused data either in rows or indexes, this excess and no longer used space is bloat. Postgres’ vacuum is your solution here for a healthy database.

A deck presented at the recent RootConf.

Containers are great for local development, and often for deploying apps, but connecting into one can require more nuance than you might think. Here’s a crash course in simplifying it.

Remote DBA combined with our 24/7 Production Support: monitoring, managing and a rapid fix for PostgreSQL database issues.