Postgres Pro
Downloads
Home   >   mailing lists

Re: partitioning and locking problems - Mailing list pgsql-performance

From Simon Riggs
Subject Re: partitioning and locking problems
Date
Msg-id 1139387429.1258.248.camel@localhost.localdomain
Whole thread Raw
In response to Re: partitioning and locking problems  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-performance
Tree view 
On Tue, 2006-02-07 at 18:59 -0600, Jim C. Nasby wrote:

> I'm honestly somewhat surprised someone hasn't run into this problem
> with partitioning yet; or maybe everyone who needs to do long
> transactions just shoves those off to slony slaves...

All DDL takes locks, on all DBMS.

Best Regards, Simon Riggs

pgsql-performance by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Default autovacuum settings too conservative
Next
From: Markus Schaber
Date:
Subject: Re: Default autovacuum settings too conservative