Re: 9.1 vs 8.4 performance

One thing I sometimes forget to do after loading up an empty DB with data is to run "analyze".  I usually "remember"
onceI see poor query performance, run the analyze, and its fixed. 

-----Original Message-----
From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Scott Marlowe
Sent: Friday, September 21, 2012 3:01 PM
To: salah jubeh
Cc: pgsql
Subject: Re: [GENERAL] 9.1 vs 8.4 performance

On Fri, Sep 21, 2012 at 8:32 AM, salah jubeh <s_jubeh@yahoo.com> wrote:
> Hello,
>
> I have two postgresql servers 9.1.5 and 8.4.8  running on ubuntu
> machine, both are fresh installs and both has the same configuration
> files and databases.
>
> I am running queries sequentially on each machine using a database
> dumped from a life server ,  and 9.1 server is much slower than 8.4.

So how different or similar are these two machines?


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general