Re: [PATCHES] Big number of "unused" pages as reported by VACUUM

> I make a guess I've got this due to parallel running of a program making
> bulk INSERTs/UPDATEs into that table. Mmm...I need a way to avoid the big
> number of unused pages in such a case. LOCK TABLE?

Well, I suggest doing a normal vacuum analyze ('VACUUM ANALYZE goods') after
every bulk insert/update.  This will go through the table and mark all new
outdated tuples as re-usable.  That way, when you do your next bulk
insert/update it will be able to reuse the unused tuples.  Give that a
try...

Chris