On 10/23/07, Brad King <brad.king@channeladvisor.com> wrote:
> Let me re-phrase this to see if I can get any response. Has anyone used
> partitioning with inheritance successfully ? Can you point to any
> specific concurrency strategies for garbage collecting old partitions on
> a live system ? Thank you.
I've never truncated on a live one. It is pretty easy to just update
the update/insert rules/triggers to ignore the old table, then drop
it. I'm guessing you could do that, then recreate the table and get
good performance.