On Thu, Sep 01, 2005 at 02:04:54PM -0400, Merlin Moncure wrote:
> > Any help most gratefully received (even if it's to say that I should
> be
> > posting to a different mailing list!).
>
> this is correct list. did you run vacuum/analyze, etc?
> Please post vacuum analyze times.
2005-09-01 19:47:08 LOG: statement: vacuum full analyze address;
2005-09-01 19:48:44 LOG: duration: 96182.777 ms
2005-09-01 19:50:20 LOG: statement: vacuum analyze address;
2005-09-01 19:51:48 LOG: duration: 87675.268 ms
I run them regularly, pretty much after every bulk import.
Matthew