Request a Demo
Home   >   mailing lists

Re: vacuum taking an unusually long time - Mailing list pgsql-general

From Mason Hale
Subject Re: vacuum taking an unusually long time
Date
Msg-id [email protected]
Whole thread Raw
In response to Re: vacuum taking an unusually long time  ("Scott Marlowe" <[email protected]>)
Responses Re: vacuum taking an unusually long time
List pgsql-general
Tree view
None of these values have changed recently.

The values are:

vacuum_cost_delay = 10ms
vacuum_cost_limit = 200

Are there any other values I should be looking at?

The longest running vacuum has been running more than 6 days at this point.

Thanks,
Mason

On Mon, Jul 14, 2008 at 4:39 PM, Scott Marlowe <[email protected]> wrote:
On Mon, Jul 14, 2008 at 3:08 PM, Mason Hale <[email protected]> wrote:
> Vacuum operations on several tables are taking much longer than they
> previously were.
> We currently have 3 autovacuum processes that have been running more than 3
> days each.
> The tables are large (between 40 and 90GB each).
> Postgresql version is 8.3.1
> maintenance_work_mem is 512MB  (on a 32GB server).
> Any ideas what would make vacuum take so long?
> What can I do to speed things up?

Have you adjusted your vacuum / autovacuum cost parameters up?  that
will certainly slow down vacuums.

--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: C-procedure crashed in Postgres 8.3.3 when using 'text' variable (WinXP)
Next
From: Josh Berkus
Date:
Subject: Re: [pgsql-advocacy] [pdxpug] Pg booth staffing at OSCON