Re: [PERFORM] Missing the point of autovacuum

2007-01-06 Thread Tom Lane
Daryl Herzmann <[EMAIL PROTECTED]> writes: > As the months have gone by, I notice many of my tables having *lots* of > unused item pointers. For example, > There were 31046438 unused item pointers. > Total free space (including removable row versions) is 4894537260 bytes. > 580240 pages are or w

Re: [PERFORM] Missing the point of autovacuum

2007-01-06 Thread Tobias Brox
[Daryl Herzmann - Sat at 12:59:03PM -0600] > As the months have gone by, I notice many of my tables having *lots* of > unused item pointers. For example, Probably not the issue here, but we had some similar issue where we had many long-running transactions - i.e. some careless colleague entering