Search Postgresql Archives

Re: CPU-intensive autovacuuming

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux