Postgres Guide is a guide I’ve maintained for a few years, meant to be a getting started for Postgres. It recently got a bit make over, take a look and if you want to help contributions are always welcome.

Postgres keeps a lot of stats about your data and your queries and these are easy to access yourself with a little know how. This is a great guide to understanding more of your Postgres stats.

Here’s a special deal on the popular foundational course for Postgres Administration. This is beneficial if you are new to Postgres but have used other databases, or if you want to refresh your knowledge and get a BONUS 9.4 certification free. Use promo code PGW-WEB-10 for 10% off.

Bloom filters are a probabilistic data structure that are space efficient for membership queries in a set of data (at the cost of false positives).Here’s a great walk through of recreating their functionality in Postgres.

pg_shard is one of the few options for ‘out of the box’ sharding with Postgres. It’s gotten some new updates to continue rounding out rough edges, so if you’re needing to shard, give it a look.

There’s only a few key Postgres conferences each year, a newer one among those is PGConf Silicon Valley. Proving to have a great lineup from Postgres hackers and users, if you’re looking for a Postgres conference this is one to consider.

For the second time in as many weeks we’ve got a post talking about the issues of transaction wrap-around in Postgres. If you’ve got a high throughput system, or appreciate interesting detailed postmortems, this is a good read.

Sure JSONB works well with many modern ORMs and frameworks such SQLAlchemy in Python or even in Rails, but it also can be a good solution with more enterprise architectures as shown here with Hibernate JPAs.

Namely is an agile startup dedicated to building an end-to-end HR platform for businesses of all sizes. We’re looking for a skilled developer to contribute ideas, innovation, solutions and code to our product.

Toptal is an exclusive network of elite freelance software engineers. Apply today to work with top clients, set your own rates, and collaborate with other top PostgreSQL developers.