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: 2007-05-11 02:05:01
Message-ID: 200705110205.l4B251ns016170@larrys.harvard.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Browse pgsql-performance by date

  From Date Subject
Next Message Adam Witney 2007-05-11 13:35:03 Re: Best OS for Postgres 8.2
Previous Message Ron Mayer 2007-05-11 00:10:56 Re: Background vacuum