We feature a lot of articles about using Postgres, sometimes some about the community, but rarely a look at the code underneath that powers the database we love. Here’s a great inspection of some of the Postgres core code.

Postgres supports a number of index types, though hash indexes come with a big warning on the box. So why do they even exist? They can yield some extra performance in certain cases as demonstrated here, but use them in production at your own risk.

A common argument against NoSQL is a lack of enforced conditions around your data. However, with Postgres you can use constraints on your JSON data and enforce good practices.

Accelerate your learning with training taught by Postgres Community Leader Bruce Momjian. Designed for database professionals responsible for administration and maintenance of PostgreSQL. Increase proficiency and learn best practices. Space is limited – sign up today.

Spawned in part by an email response on the pgsql-hackers list that read “Yeha!”… this followup patch greatly reduces certain cases where full table vacuums are needed. The short of this means the impact of vacuum wraparound is greatly reduced.

pg_pathman is an extension that accelerates query planning over partitioned tables, but how does it work with filters?

Pipeline is an open-source relational database that runs SQL queries continuously on streams.

A look at working with large hierarchical structures in Rails with Postgres.

Come work with us as we rethink the tech stack for financial services. We need folks who are experts in database systems and are eager to make a big impact.

Indeed Prime is an elite new program from Indeed.com that presents in-demand tech talent like you to top employers. Indeed Prime opens the door to exciting career opportunities with one simple application. Join today!