Thursday, April 21, 2016

PostgreSQL 9.6 with Parallel Query vs. TPC-H

›
I decided to try out parallel query, as implemented in PostgreSQL 9.6devel, on the TPC-H queries.  To do this, I followed the directions at ...
12 comments:
Monday, March 21, 2016

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 please...
8 comments:
Thursday, March 10, 2016

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. " ...
7 comments:
Tuesday, January 12, 2016

PostgreSQL Past, Present, and Future: Moving The Goalposts

›
It's nice to see that PostgreSQL 9.5 is finally released!  There are a number of blog posts out about that already, not to mention stor...
79 comments:
Wednesday, November 11, 2015

Parallel Sequential Scan is Committed!

›
I previously suggested that we might be able to get parallel sequential scan committed to PostgreSQL 9.5.  That did not happen.  However, I...
59 comments:
Friday, October 30, 2015

Planning Parallel and Distributed Queries

›
I have been somewhat lax about blogging for the last six months or so due to having been even busier than usual with various projects, and I...
Tuesday, March 31, 2015

PostgreSQL Shutdown

›
PostgreSQL has three shutdown modes: smart, fast, and immediate.  For many years, the default has been "smart", but Bruce Momjian ...
3 comments: