On 10/23/07, Brad King <brad.king@xxxxxxxxxxxxxxxxxx> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
