Re: [GENERAL] Controlling maximal on-disk size of a table

2004-11-17 Thread David Helgason
What you're looking for sounds like and extended (destructive) version of what autovacuum does. So you might try to look at the statistics tables like autovacuum does. I don't know how it does that, but it seems that that way you'd be able to incrementally have approximate information about wha

[GENERAL] Controlling maximal on-disk size of a table

2004-11-16 Thread Nils Rennebarth
I have a table that is essentially a log where new entries are streaming in continually and from time to time I throw old entries away to keep the table from growing. I understand that in addition to issue a DELETE FROM log WHERE date < xxx I also need to issue a VACUUM log so that new entri