Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: VACUUM ANALYZE suddenly taking forever
- From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
- To: Nolan Cafferky <Nolan(dot)Cafferky(at)rbsinteractive(dot)com>
- Cc: pgsql-admin(at)postgresql(dot)org
- Subject: Re: VACUUM ANALYZE suddenly taking forever
- Date: Thu, 27 Jul 2006 11:31:43 -0400
Nolan Cafferky wrote: > The so far untried ideas I've had are: > > * Try out the autovacuum service > * Re-index tables (this hasn't been done for at least months, maybe never) > * Do some selective VACUUM FULL on high-use tables (materialized view > for report seems like a likely culprit, but also seems like it wouldn't > influence both databases) > * Restart postgres, restart the machine itself, and other useless handwaving * Check whether there are open, idle transactions and close them -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support
- References:
- VACUUM ANALYZE suddenly taking forever
- From: Nolan Cafferky
- VACUUM ANALYZE suddenly taking forever
- Prev by Date: VACUUM ANALYZE suddenly taking forever
- Next by Date: Re: [SQL] PostgreSQL server terminated by signal 11
- Previous by thread: VACUUM ANALYZE suddenly taking forever
- Next by thread: Re: VACUUM ANALYZE suddenly taking forever
- Indexes: