From: Simon Riggs <simon@2ndquadrant.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Marc Morin <marc@sandvine.com>
Cc: Markus Schaber <schabi@logix-tt.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: partitioning and locking problems
Date: Wed, 08 Feb 2006 08:30:29 +0000
Message-ID: <1139387429.1258.248.camel@localhost.localdomain> (raw)
In-Reply-To: <20060208005912.GS38134@pervasive.com>
References: <2BCEB9A37A4D354AA276774EE13FB8C2BCC2A6@mailserver.sandvine.com>
<1139350142.1258.174.camel@localhost.localdomain>
<20060208005912.GS38134@pervasive.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: simon@2ndquadrant.com, jnasby@pervasive.com, marc@sandvine.com, schabi@logix-tt.com
Subject: Re: partitioning and locking problems
In-Reply-To: <1139387429.1258.248.camel@localhost.localdomain>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox