Re: CPU-intensive autovacuuming

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Phil Endecott <spam_from_postgresql_general(at)chezphil(dot)org>
Cc: "Matthew T(dot) O'Connor" <matthew(at)zeut(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: CPU-intensive autovacuuming
Date: 2005-06-07 16:04:28
Message-ID: 200506071604.j57G4Sr18799@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Phil Endecott wrote:
> Matthew T. O'Connor wrote:
> > The integrated version
> > of autovacuum that didn't make the cut before 8.0 avoids this problem
> > since the autovacuum data is stored in the database.
>
> What is the status of this? Is it something that will be included in
> 8.1 or 8.0.n? I might be able to patch the current code but that
> doesn't seem like a useful thing to do if a better solution will arrive
> eventually. I am currently running vacuums from a cron job and I think
> I will be happy with that for the time being.

I will post about integrating pg_autovacuum into the backend for 8.1 in
a few minutes.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2005-06-07 16:15:21 Re: Debian Stable goes from Woody to Sarge!!
Previous Message Matthew T. O'Connor 2005-06-07 16:00:54 Re: CPU-intensive autovacuuming

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-06-07 16:38:08 Re: copying a bucket to a BufFile
Previous Message mchron 2005-06-07 16:04:02 copying a bucket to a BufFile