When you delete a row in Postgres, it doesn’t actually delete, well it does eventually. When you delete a row it marks it as logically deleted, here’s how you can ensure it’s gone as well as a read on how it works with MVCC under the covers.
Discover a collaborative and entirely browser-based environment for your team's queries and data-driven insights. JackDB adds a security layer to your organization's entire data infrastructure. Try it for free.
JSONB arrived in Postgres 9.4 to a lot of excitement, but how does it really measure up? Here’s a look a performance, and how to really take advantage of it with the new operators which can utilize GIN indexes.
Foreign tables now present an even cleaner solution for partitioning your data with inheritance. While you’ll have to wait a little until 9.5 is available, this feature clearer can make the scale out process in Postgres a bit more comfortable for all.
CStore - The fast and open source columnar store for analytics with PostgreSQL just received a new release which features some nice improvements. If you haven’t played with it yet, this is a good excuse.
Any article that starts off “PostgreSQL is so much more than a simple relational data store” makes me happy. A look at how Postgres is not only a great relational database, but can also work as a very solid queue for your application.