From: Scott Marlowe <scott.marlowe@gmail.com>
To: Dai, Tino <tdai@loc.gov>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Disparity between 8.1.18 and 8.2.14 performance wise
Date: Mon, 22 Mar 2010 16:32:22 -0600
Message-ID: <dcc563d11003221532j51c88123tbd71fc0144a33775@mail.gmail.com> (raw)
In-Reply-To: <1CA7FF980DA3824F9A5C31532B7A40DCC4B87E10@LCXCLMB01.LCDS.LOC.GOV>
References: <1CA7FF980DA3824F9A5C31532B7A40DCC4B87E10@LCXCLMB01.LCDS.LOC.GOV>
On Mon, Mar 22, 2010 at 3:58 PM, Dai, Tino <tdai@loc.gov> wrote:
> After many days of googling and referring to different web pages about performance, I'm
> turning to this list for help. We have a third party application that is running on 8.1.11 and the
> vendor has told us not to upgrade the database to 8.2.
>
> I have gone with the default values in postgresql.conf of 8.1.18 (the 8.1.11 was unavailable
> from the postgresql site so this is the closest one) and 8.2.14. I execute the same query with
> EXPLAIN ANALYZE on 8.1.18 and the 8.2.14. The 8.1.18 comes back with about 1000ms -1100ms
> while the 8.2.14 comes back with 5ms - 6ms.
That's a factor of about 200 times faster for 8.2.
> I have tried up the work_mem, effective_cache_size, and the shared_buffers with no noticeable effect.
> I'm not looking for a magic wand to allow 8.1.18 to become 8.2.14, but some performance gain would be
> nice. Can any shed some light on this?
Why?
> Filter: (((section)::text = (section)::text) AND (ref_id = ref_id))
> Total runtime: 6.905 ms
Is this the result from 8.2? Cause it's not 6 seconds, it's 6 milliseconds..
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, tdai@loc.gov
Subject: Re: Disparity between 8.1.18 and 8.2.14 performance wise
In-Reply-To: <dcc563d11003221532j51c88123tbd71fc0144a33775@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox