> 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