X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 89B399DC9C2 for ; Wed, 1 Feb 2006 10:26:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 56443-04 for ; Wed, 1 Feb 2006 10:26:48 -0400 (AST) X-Greylist: delayed 15:00:16.645393 by SQLgrey- Received: from mailserver.sandvine.com (sandvine.com [199.243.201.138]) by postgresql.org (Postfix) with ESMTP id E21C69DC95A for ; Wed, 1 Feb 2006 10:26:33 -0400 (AST) X-MimeOLE: Produced By Microsoft Exchange V6.0.6603.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Subject: Re: partitioning and locking problems Date: Wed, 1 Feb 2006 09:25:10 -0500 Message-ID: <2BCEB9A37A4D354AA276774EE13FB8C263B3E5@mailserver.sandvine.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [PERFORM] partitioning and locking problems Thread-Index: AcYm8yR8SnYsjNKzRHWIzwA73vW9lgASBveA From: "Marc Morin" To: "Tom Lane" Cc: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.12 required=5 tests=[AWL=0.120] X-Spam-Score: 0.12 X-Spam-Level: X-Archive-Number: 200602/12 X-Sequence-Number: 16998 Tom, Do you mean it would be impossible to change the code so that existing selects continue to use the pre-truncated table until they commit? Or just require a more extensive change? The update/insert rule change appears to be more more doable? No?=20 > -----Original Message----- > From: Tom Lane [mailto:tgl@sss.pgh.pa.us]=20 > Sent: Wednesday, February 01, 2006 12:50 AM > To: Marc Morin > Cc: pgsql-performance@postgresql.org > Subject: Re: [PERFORM] partitioning and locking problems=20 >=20 > "Marc Morin" writes: > > Would like to understand the implications of changing postgres' > > code/locking for rule changes and truncate to not require=20 > locking out=20 > > select statements? >=20 > It won't work... >=20 > regards, tom lane >=20 >=20