Re: large table vacuum issues

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: large table vacuum issues
Date: 2008-01-05 01:29:09
Message-ID: 200801041829.10350.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday 04 January 2008 6:21 pm, Scott Marlowe wrote:
>
> Have you tried adjusting the
>
> #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 # 0-10000 credits
>
> settings to something so as to make vacuum less intrusive?
> might be the easiest fix.

Any particular suggested changes for these parameters?

Ed

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ed L. 2008-01-05 01:41:03 Re: large table vacuum issues
Previous Message Scott Marlowe 2008-01-05 01:21:13 Re: large table vacuum issues