| From: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Autovacuum / full vacuum |
| Date: | 2006-01-17 15:09:48 |
| Message-ID: | 20060117150948.GG21092@phlogiston.dyndns.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Tue, Jan 17, 2006 at 09:09:02AM -0500, Matthew T. O'Connor wrote:
> vacuum. As long as that percentage is small enough, the effect on
> performance is negligible. Have you measured to see if things are truly
Actually, as long as the percentage is small enough and the pages are
really empty, the performance effect is positive. If you have VACUUM
FULLed table, inserts have to extend the table before inserting,
whereas in a table with some space reclaimed, the I/O effect of
having to allocate another disk page is already done.
A
--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
When my information changes, I alter my conclusions. What do you do sir?
--attr. John Maynard Keynes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | hubert depesz lubaczewski | 2006-01-17 15:10:34 | Re: Autovacuum / full vacuum |
| Previous Message | Andrew Sullivan | 2006-01-17 15:08:00 | Re: Autovacuum / full vacuum |