Re: [GENERAL] Checking for old transaction snapshots

2005-08-17 Thread Alvaro Herrera
On Sun, Aug 14, 2005 at 11:26:33AM -0400, Greg Stark wrote: > > I have a job that does a big batch delete/insert. I want it to vacuum (or > probably cluster) when it's finished. But I figure I should sleep for a while > before doing the vacuum to be sure there are no old transactions still > runni

[GENERAL] Checking for old transaction snapshots

2005-08-14 Thread Greg Stark
I have a job that does a big batch delete/insert. I want it to vacuum (or probably cluster) when it's finished. But I figure I should sleep for a while before doing the vacuum to be sure there are no old transactions still running. Is there a simple query I can have it do against the system table