Re: Massive performance issues - Mailing list pgsql-performance

From Matthew Sackman
Subject Re: Massive performance issues
Date
Msg-id 20050901185231.GA7131@pongo.lshift.net
Whole thread Raw
In response to Re: Massive performance issues  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: Matthew Sackman
Date:
Subject: Re: Massive performance issues
Next
From: Tom Lane
Date:
Subject: Re: Massive performance issues