Postgres Pro
Downloads
Home   >   mailing lists

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

From Mason Hale
Subject vacuum taking an unusually long time
Date
Msg-id 8bca3aa10807141408j4b82fd3dl99582c3f67fe8152@mail.gmail.com
Whole thread Raw
Responses Re: vacuum taking an unusually long time
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: SPACE FOR POSTGRESQL DATABASE
Next
From: Bruce Momjian
Date:
Subject: Re: statement timeout and pg_dump