Postgres Pro
Downloads
Home   >   mailing lists

Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7 - Mailing list pgsql-performance

From Susan Russo
Subject Re: REVISIT specific query (not all) on Pg8 MUCH slower than Pg7
Date
Msg-id 200705110205.l4B251ns016170@larrys.harvard.edu
Whole thread Raw
In response to REVISIT specific query (not all) on Pg8 MUCH slower than Pg7  (Susan Russo <russo@morgan.harvard.edu>)
List pgsql-performance
Tree view 
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

pgsql-performance by date:

Previous
From: Ron Mayer
Date:
Subject: Re: Background vacuum
Next
From: Adam Witney
Date:
Subject: Re: Best OS for Postgres 8.2