From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | robcron <rocron(at)pssd(dot)com> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Slower Performance on Postgres 9.1.6 vs 8.2.11 |
Date: | 2012-10-26 19:58:32 |
Message-ID: | 1901.1351281512@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
robcron <rocron(at)pssd(dot)com> writes:
> Our IT group took over an app that we have running using postgres and it has
> been on version 8.2.11 since we acquired it. It is time to get current, so
> I have created instances of our production database that mirror exact
> hardware for our existing implementation on version 8.2.11 (running Fedora
> Core 8 - wow I know) and also version 9.1.6 on Fedora 17. I am able to
> mimic the production 8.2 environment exactly without any of the load of
> production and the same for the new 9.1 environment so there is no
> perverting of numbers based on load that I can't control
> Machines are Cloud based images running 4 (dual Core) Processors, with 15GB
> of memory... AMAZON m1.Xlarge boxes - 64 bit OS.
Hm ... Amazon cloud is not exactly known for providing rock-stable
performance environment, but anyway the first thing I would have guessed
at, seeing that the plans are basically the same, was a non-C locale
setting. Another thing to check is whether the new machine has higher
timing overhead --- is the speed difference the same when you just run
the query, rather than EXPLAIN ANALYZE'ing it? (If not,
contrib/pg_test_timing from 9.2 or later might yield useful data.)
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Jeff Janes | 2012-10-26 20:14:14 | Re: Query-Planer from 6seconds TO DAYS |
Previous Message | Shaun Thomas | 2012-10-26 19:57:14 | Re: Setting Statistics on Functional Indexes |