From: | Jean-Christophe Praud <jc(at)steek(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: vacuum won't even start |
Date: | 2009-09-09 16:27:15 |
Message-ID: | 4AA7D763.7000602@steek.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alvaro Herrera a écrit :
> Jean-Christophe Praud wrote:
>
>> Hi all,
>>
>> I've a problem on a heavy loaded database: vacuums don't work since
>> about a week. All I got is:
>>
>> mybase=# vacuum verbose analyze public.mytable;
>> INFO: vacuuming "public.mytable"
>> (I stop it after hours)
>>
>> Looking with top and iotop, I see the process takes some cpu and
>> disk io time during several minutes, then it seems to fall asleep.
>> The process isn't locked according to pg_stat_activity.
>>
>
> What are your vacuum_cost_% parameters?
>
>
I've let the default values (not even uncommented in the conf file ;) ):
#vacuum_cost_delay = 0 # 0-1000 milliseconds
#vacuum_cost_page_hit = 1 # 0-10000 credits
#vacuum_cost_page_miss = 10 # 0-10000 credits
#vacuum_cost_page_dirty = 20 # 0-10000 credits
#vacuum_cost_limit = 200 # 1-10000 credits
--
JC
Ph'nglui mglw'nafh Cthulhu n'gah Bill R'lyeh Wgah'nagl fhtagn!
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Christophe Praud | 2009-09-09 16:43:51 | Re: vacuum won't even start |
Previous Message | Tom Lane | 2009-09-09 16:14:40 | Re: vacuum won't even start |