| From: | Jeff Janes <jeff(dot)janes(at)gmail(dot)com> |
|---|---|
| To: | 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 18:40:52 |
| Message-ID: | CAMkU=1xAMityjoNmpnXziJqwH5ajfuwPWBkH1aGv6pvUngiLrQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Sep 21, 2012 at 7: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.
>
> I am wondering what might be the cause for this behaviour? Does 9.1
> requires more attention on setting some parameters .. ?
At this level of detail, it is impossible to give an answer. Some
people will find 9.1 faster, some slower. I suspect more will find it
faster than slower.
Can you provide an easily reproducible test case?
Cheers,
Jeff
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Victor Yegorov | 2012-09-21 18:41:46 | Re: Why do I have holes in my pages? |
| Previous Message | Jeff Janes | 2012-09-21 18:30:03 | Re: Why do I have holes in my pages? |