On Mon, 2006-05-22 at 23:55, Jim C. Nasby wrote: > BTW, there's a bug/issue with CLUSTER that makes it not entirely > transaction safe.
For God's sake, don't fix that one ! I rely on it... now seriously, until there's a way to tell the DB that an exclusive lock is enough to vacuum all dead rows, even if they would be visible by other transactions, CLUSTER is the only thing I can use to circumvent the long running transaction syndrome. Cheers, Csaba. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend