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). How can I issue a truncate /drop table on the child without running into locking issues. Doesn't constraint exclusion prevent access of a child table based on the check constraint criteria -----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] Sent: Monday, June 19, 2006 11:27 AM To: Sriram Dandapani Cc: pgsql-admin@xxxxxxxxxxxxxx Subject: Re: [ADMIN] truncate partitioned table locking "Sriram Dandapani" <sdandapani@xxxxxxxxxxxxxxx> writes: > I have master table A, inherited by Table B and Table C > Does the truncation of a child table take a lock on the master table ? No, but it certainly locks the child table ... and queries on A are going to try to scan all three tables. regards, tom lane
