From: | "Benjamin Krajmalnik" <kraj(at)illumen(dot)com> |
---|---|
To: | "Sriram Dandapani" <sdandapani(at)counterpane(dot)com> |
Cc: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: truncate partitioned table locking |
Date: | 2006-06-19 19:45:41 |
Message-ID: | BF337097BDD9D849A2F4B818DDB27987029366@stash.stackdump.local |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Sriram Dandapani
Sent: Monday, June 19, 2006 12:41 PM
To: Tom Lane
Cc: pgsql-admin(at)postgresql(dot)org
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).
From | Date | Subject | |
---|---|---|---|
Next Message | Sriram Dandapani | 2006-06-19 19:50:23 | Re: truncate partitioned table locking |
Previous Message | Sriram Dandapani | 2006-06-19 18:41:05 | Re: truncate partitioned table locking |