Re: [PATCHES] Big number of "unused" pages as reported by VACUUM - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: [PATCHES] Big number of "unused" pages as reported by VACUUM
Date
Msg-id GNELIHDDFBOCMGBFGEFOCEBNCEAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: [PATCHES] Big number of "unused" pages as reported by  (Yury Bokhoncovich <byg@center-f1.ru>)
List pgsql-hackers
> 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



pgsql-hackers by date:

Previous
From: Hannu Krosing
Date:
Subject: Re: Inheritance
Next
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: [PATCHES] Big number of "unused" pages as reported by