| From: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com> |
|---|---|
| To: | Elanchezhiyan Elango <elanelango(at)gmail(dot)com> |
| Cc: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuuming strategy |
| Date: | 2014-04-30 20:06:16 |
| Message-ID: | CAL_0b1uhjoic=7xaEEY9y0mvP7xU9=xLod6N7pXzY771WOw-Dg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Wed, Apr 30, 2014 at 10:40 AM, Elanchezhiyan Elango
<elanelango(at)gmail(dot)com> wrote:
> log_autovacuum_min_duration = 0
>
> autovacuum_vacuum_scale_factor = 0
> autovacuum_vacuum_threshold = 40000
> autovacuum_analyze_scale_factor = 0
> autovacuum_analyze_threshold = 40000
I don't think it is a good idea to set scale factor and this high
threshold instance wide. You can try per table settings instead if you
want.
--
Kind regards,
Sergey Konoplev
PostgreSQL Consultant and DBA
http://www.linkedin.com/in/grayhemp
+1 (415) 867-9984, +7 (499) 346-7196, +7 (988) 888-1979
gray(dot)ru(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Joe Conway | 2014-04-30 22:53:42 | Re: arrays of rows and dblink |
| Previous Message | David G Johnston | 2014-04-30 19:02:38 | Re: arrays of rows and dblink |