Re: Postgresql backend to perform vacuum automatically - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Postgresql backend to perform vacuum automatically
Date
Msg-id 200203050605.g25656c20570@candle.pha.pa.us
Whole thread Raw
In response to Re: Postgresql backend to perform vacuum automatically  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
List pgsql-hackers
> vacuum_idle_threshold
> = system load below which the system must be before a vacuum can be
> performed.  0 = no requirement
> 
> vacuum_time_threshold
> = seconds since last vacuum before which another vacuum cannot occur. 0 = no
> requirement.
> 
> If all 3 are 0, then no auto-vacuuming is performed at all.  There's
> probably trouble if only the idle threshold is set to zero.
> 
> And the same for the 'analyze' command?
> 
> If they want it on a per-table basis, then they can just do it themselves
> with a cronjob!

Yes, and Jan's statistics stuff has stats on table activity.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Christopher Kings-Lynne"
Date:
Subject: Re: Postgresql backend to perform vacuum automatically
Next
From: Bruce Momjian
Date:
Subject: Re: Please, apply patch for contrib/tsearch