Re: Partitioning and deadlocks

["Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>]

On 10/23/07, Brad King <brad(dot)king(at)channeladvisor(dot)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.