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

[PERFORM] Missing the point of autovacuum

2007-01-06 Thread Daryl Herzmann
Greetings, I've been running Postgresql for many years now and have been more than happy with its performance and stability. One of those things I've never quite understood was vacuuming. So I've been running 8.1.4 for a while and enabled 'autovacuum' when I first insalled 8.1.4 ... So in my