Log Buffer #177: a Carnival of the Vanities for DBAs
Welcome, everyone, to the 177th edition of Log Buffer, the weekly review of database blogs. It was another week heavy with technical posts, so let’s waste no time, and get it all started with . . .
PostgreSQL
David Fetter shares his recipe for adding only new rows: “Let’s say you have a table and a data set, and would like to add only those rows in your data set that aren’t already in the table. There are hard ways, but here’s an easy one.”
Simon Riggs, the Database Explorer, offers his thoughts on parallel query in Postgres: “I’m disappointed we’ve not made much progress with parallel operations and partitioning in core Postgres in last few releases. Recent Greenplum results show we have much work to do in improving things.”
David Christensen shares a PostgreSQL tip: using pg_dump to extract a single function.
Robert Gravsjö shares a screenshot of the new Sun Oracle PostgreSQL. That doesn’t even sound right, does it?

