| From: | "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, salah jubeh <s_jubeh(at)yahoo(dot)com> |
| Cc: | pgsql <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 9.1 vs 8.4 performance |
| Date: | 2012-09-21 19:40:41 |
| Message-ID: | 0AD01C53605506449BA127FB8B99E5E118035976@FMSMSX105.amr.corp.intel.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
One thing I sometimes forget to do after loading up an empty DB with data is to run "analyze". I usually "remember" once I see poor query performance, run the analyze, and its fixed.
-----Original Message-----
From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-owner(at)postgresql(dot)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(at)yahoo(dot)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(at)postgresql(dot)org) To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2012-09-21 19:42:17 | Re: Expression to construct a anonymous record with named columns? |
| Previous Message | Gauthier, Dave | 2012-09-21 19:38:24 | Re: 9.1 vs 8.4 performance |