Re: Question about VACUUM

From: Ernesto Quiñones <ernestoq(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Question about VACUUM
Date: 2011-12-05 17:46:48
Message-ID: CAMB2kH5gOudkM-UyO3ie_WfHi8PprrdAMHU_L-4eUyp+K7UN2Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

no problem Scott, thanks for your appreciations

2011/12/5 Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
> On Mon, Dec 5, 2011 at 10:42 AM, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> wrote:
>> On Mon, Dec 5, 2011 at 10:19 AM, Ernesto Quiñones <ernestoq(at)gmail(dot)com> wrote:
>>> vacuum_cost_delay       1s
>>> vacuum_cost_limit       200
>>
>> Those are insane settings for vacuum costing, even on a very slow
>> machine.  Basically you're starving vacuum and autovacuum so much that
>> they can never keep up.
>
> sorry, the word I meant there was pathological.  No insult intended.

--
----------------------------------------------------------
Visita : http://www.eqsoft.net
----------------------------------------------------------
Sigueme en Twitter : http://www.twitter.com/ernestoq

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Bruce Momjian 2011-12-05 18:22:56 Re: pg_upgrade
Previous Message Scott Marlowe 2011-12-05 17:44:07 Re: Question about VACUUM