Monday, March 26, 2012

Why Is My Database Corrupted?

›
Working in the support department ( as I do ) is a good way to hear lots of horror stories.  From time to time, we get reports of what can o...
11 comments:
Thursday, March 15, 2012

Tuning shared_buffers and wal_buffers

›
I spend a lot of time answering questions about PostgreSQL, and one of the questions I get asked frequently is: how should I set shared_buff...
19 comments:
Wednesday, March 14, 2012

Security Barrier Views

›
People sometimes want to use PostgreSQL to implement row-level security, and historically it has not been very easy to do that securely.  Yo...
2 comments:
Monday, March 12, 2012

First Results for Write Performance on IBM POWER7

›
In a previous blog post , I posted some SELECT-only pgbench results on IBM POWER7, and promised to post read-write results when I had them. ...
2 comments:
Monday, March 05, 2012

The Perils of Collation-Aware Comparisons

›
If you use psql's \l command to list all the databases in your PostgreSQL cluster, you'll notice a column in the output labelled ...
9 comments:
Friday, March 02, 2012

The Git Workflow

›
When the PostgreSQL project decided to migrate to git , we decided not to allow merge commits.  A number of people made comments, in a numb...
9 comments:
Thursday, March 01, 2012

Performance and Scalability on IBM POWER7

›
I recently had a chance to run some benchmarks of PostgreSQL 9.2devel on an IBM POWER7 machine provided by IBM and hosted by Oregon State U...
8 comments: