vacuum taking an unusually long time

From: "Mason Hale" <masonhale(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: vacuum taking an unusually long time
Date: 2008-07-14 21:08:32
Message-ID: 8bca3aa10807141408j4b82fd3dl99582c3f67fe8152@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

thanks,
- Mason

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2008-07-14 21:16:56 Re: statement timeout and pg_dump
Previous Message Bruce Momjian 2008-07-14 20:21:00 Re: SPACE FOR POSTGRESQL DATABASE