X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id B70619F9FE3 for ; Mon, 19 Jun 2006 16:45:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 85651-06 for ; Mon, 19 Jun 2006 16:45:47 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from stash.illumen.com (unknown [64.207.29.137]) by postgresql.org (Postfix) with ESMTP id 7BDC49F9998 for ; Mon, 19 Jun 2006 16:45:45 -0300 (ADT) Content-class: urn:content-classes:message Subject: Re: truncate partitioned table locking MIME-Version: 1.0 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Date: Mon, 19 Jun 2006 13:45:41 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: [ADMIN] truncate partitioned table locking thread-index: AcaTzlUpmqGeXaHtQ3+06NkC9IwD0gAASKSQAAJSEuA= From: "Benjamin Krajmalnik" To: "Sriram Dandapani" Cc: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/150 X-Sequence-Number: 22112 Sriram, I do this on monthly tables which have about 30 million rows. Last time I truncated a partition it took anout 2 milliseconds. -----Original Message----- From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Sriram Dandapani Sent: Monday, June 19, 2006 12:41 PM To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] truncate partitioned table locking=20 I have a situation where data is constantly inserted and frequently queried into a master table(and routed appropriately to the partition based on a non-overlapping check constraint ). I also need to drop the child partition (say for yesterday's data..the partitioning is done on a daily basis).