Having covered some of the reasons why you would want to run a PostgreSQL on Kubernetes , I'm not going to cover some of the reasons why...

In preparation for my workshop on running PostgreSQL on Kubernetes on Monday, I wanted to talk a bit about why you'd want to run your d...

Teal Deer: The Annotated.conf has been updated for PostgreSQL 10, and it's a Github repo now. 13 years ago, for PostgreSQL 8.0, I re...

Those of you in the PostgreSQL community will have noticed that I haven't been very active for the past year.  My new work on Linux cont...

Per yesterday's developer meeting, the PostgreSQL Project is contemplating a change to how we do version numbers.  First, let me explai...

This StackOverflow question reminded me of this old blog post, which is still relevant today: pg_log, pg_xlog and pg_clog There are ...

This year, we're continuing to experiment with new formats for the pgCon unconference.  In 2013 and 2014 we had an Unconference on the S...

We've released an off-schedule update release today , because of a bug in one of 9.5's features which has forced us to partially dis...

Just ran across this excellent pair of blog posts on using JSONB with Go application design to simplify your data model.  Since that blog is...

If you downloaded 9.5 after yesterday's release , you might have noticed some changes to postgresql.conf, especially if you copied over ...

It's been much-delayed, but PostgreSQL 9.5 RC1 is finally available .  This release contains not only fixes for all known issues in 9.5 ...

Well, this story is better told by the guy who broke it, John De Goes . The TL;DR is that MongoDB will be shipping PostgreSQL as its ...

First, in case you somehow missed it, PostgreSQL 9.5 Beta 2 is now out.  Time for another round of testing!  There's fewer and fewer bu...

My AccidentalDBA tutorial materials have been updated for pgConfSV next week.  If you are planning to take this tutorial, please read and ...

One of PostgreSQL's advantages over many other SQL databases is letting users modify database objects with a minimum of locking and fuss...

I write a lot more PL/pgSQL than I'd like to.  Not that I don't like SQL, but as a language PL/pgSQL really shows its thrown-togethe...

Since we're still working on the schedule, I wanted to give folks a preview of the talks we've picked for pgConfSV .  We still have ...

cstore_fdw , the column-store extension for PostgreSQL by CitusData, is a really good way to add compressed storage for archival data, and a...

Since Oracle was so nice as to remind everyone what software security is really like with closed-source software, I wanted to remind people...

In 9.5 Alpha 2 : create table mil ( id int, val text ); insert into mil select i, i::text || '-val'  from generate_series(1,100000...