Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
- From: Susan Russo <russo(at)morgan(dot)harvard(dot)edu>
- To: russo(at)morgan(dot)harvard(dot)edu, wmoran(at)collaborativefusion(dot)com
- Cc: harvsys(at)morgan(dot)harvard(dot)edu, pgsql-performance(at)postgresql(dot)org
- Subject: Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
- Date: Thu, 10 May 2007 22:05:01 -0400 (EDT)
Hello again - vacuum analyze of db did the trick, thanks! longer procedure went from over 6 hours to ~11 minutes....quite dramatic. Reindexing wasn't necessary (did test on one db -slog-slog-, though). Regards, Susan
- Prev by Date: Re: Background vacuum
- Next by Date: Re: Best OS for Postgres 8.2
- Previous by thread: Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
- Next by thread: Re: [PERFORM] REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
- Indexes: