| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Nicolas Bazin <nbazin(at)ingenico(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Postgresql backend to perform vacuum automatically |
| Date: | 2002-03-05 06:05:06 |
| Message-ID: | 200203050605.g25656c20570@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2002-03-05 06:10:36 | Re: Please, apply patch for contrib/tsearch |
| Previous Message | Christopher Kings-Lynne | 2002-03-05 06:03:52 | Re: Postgresql backend to perform vacuum automatically |