RE: Re: [GENERAL] Vacuum and Transactions - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject RE: Re: [GENERAL] Vacuum and Transactions
Date
Msg-id ECEHIKNFIMMECLEBJFIGAEDGCBAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to Re: Re: [GENERAL] Vacuum and Transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: [GENERAL] Vacuum and Transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> You'll still need to VACUUM to get rid of the obsoleted versions of the
> row.  The point of the planned 7.2 changes is to make VACUUM cheap and
> nonintrusive enough so that you can run it frequently on tables that are
> seeing continual updates.

If it becomes non-intrusive, then why not have PostgreSQL run VACUUM
automatically when certain conditions (user-configurable, load, changes per
table, etc.) are met.

All the sys admin would need to do is put the VACCUUM FULL in a cron job.

Chris



pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: ADD CONSTRAINT behaviour question
Next
From: "Christopher Kings-Lynne"
Date:
Subject: RE: Re: [GENERAL] Vacuum and Transactions