Profile cover photo
Profile photo
Thom Brown
About
Thom's posts

Post has attachment
Just to creep you out forever...

Post has shared content
Parallel Query Is Getting Better And Better
Back in early November, I reported that the first version of parallel sequential scan had been committed to PostgreSQL 9.6.  I'm pleased to report that a number of significant enhancements have been made since then.  Of those, the two that are by the far th...

Post has attachment

Post has attachment

Post has shared content
No More Full-Table Vacuums
I just committed a very important patch to PostgreSQL.  The short summary for the patch is " Don't vacuum all-frozen pages. " and it follows up on a patch I committed last week, whose short summary was " Change the format of the VM fork to add a second bit ...

Post has attachment

Post has shared content

Post has attachment
Looking at Peter Eisentraut's slides about the most wanted PostgreSQL features from 5 years ago, I can see that a lot of progress has been made:

1. Materialized views - done

2. Synchronous replication - done

3. Parallel query - committed and coming in 9.6

4. Index-only scans - done

5. MERGE/UPSERT/REPLACE - coming in 9.5

6. Administration and monitoring tools - well, there's pgBadger and pgCluu which are new since then, but there's room for improvement

7. In-place upgrades - done, and online upgrade should also become available once BDR makes it in, probably 9.7.

8. Partitioning - a work in progress with working patches submitted to the community

Post has shared content

Post has attachment
Wait while more posts are being loaded