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@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On Behalf Of Sriram Dandapani Sent: Monday, June 19, 2006 12:41 PM To: Tom Lane Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] truncate partitioned table locking 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).
