| From: | Ow Mun Heng <Ow(dot)Mun(dot)Heng(at)wdc(dot)com> |
|---|---|
| To: | Harald Armin Massa <haraldarminmassa(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: HouseKeeping and vacuum Questions |
| Date: | 2007-12-14 09:36:40 |
| Message-ID: | 1197625000.22167.2.camel@neuromancer.home.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, 2007-12-14 at 09:35 +0100, Harald Armin Massa wrote:
> Ow Mun Heng,
>
> The current issue which prompted me to do such housekeeping is
> due to
> long database wide vacuum time. (it went from 2 hours to 4
> hours to 7
> hours)
>
> If vacuum takes to long, you are doing it not often enough. You should
> use autovacuum, you should be able to express the delta between two
> vacuums in seconds or minutes, not hours or days.
autovacuum is already turned on and the threshold is at default
settings.
Perhaps I need to tune it to be more aggressive? how can I do that?
delta between 2 vacuums in seconds or minutes? that would be nice.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Markus Schiltknecht | 2007-12-14 09:39:40 | Re: [GENERAL] Slow PITR restore |
| Previous Message | bookman bookman | 2007-12-14 09:29:21 | How can i deal with "\n" when copy tables from sqlserver2005 to postgre? |