Postgres Pro
Downloads
Home   >   mailing lists

Re: 8.2.4 serious slowdown - Mailing list pgsql-general

From Scott Marlowe
Subject Re: 8.2.4 serious slowdown
Date
Msg-id dcc563d10801101043t12df0f7cjee0e987f99fbc9e1@mail.gmail.com
Whole thread Raw
In response to Re: 8.2.4 serious slowdown  (Sim Zacks <sim@compulab.co.il>)
List pgsql-general
Tree view 
On Jan 10, 2008 10:50 AM, Sim Zacks <sim@compulab.co.il> wrote:
> I meant I did Vacuum Analyze.
> In any case, Aside from the vacuum analyze, I also tested it right after a database restore, so there should be no
needfor any maintenance features. 

FYI, a restore does NOT restore the stats, nor does it automatically
update them.  You have to run an analyze after a restore to get the
stats updated.

pgsql-general by date:

Previous
From: Greg Smith
Date:
Subject: Re: ATTN: Clodaldo was Performance problem. Could it be related to 8.3-beta4?
Next
From: Ron Mayer
Date:
Subject: Re: count(*) and bad design was: Experiences with extensibility