From: Harry Jackson <harryjackson@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: PostgreSQL performance question.
Date: Sun, 18 Dec 2005 02:11:16 +0000
Message-ID: <45b42ce40512171811r293e254ex94a4e69910f80466@mail.gmail.com> (raw)
In-Reply-To: <43A0CEAA.6060800@familyhealth.com.au>
References: <45b42ce40512141751i6829eec0q6d088b1ec5bc27b4@mail.gmail.com>
<43A0CEAA.6060800@familyhealth.com.au>
On 12/15/05, Christopher Kings-Lynne <chriskl@familyhealth.com.au> wrote:
> PostgreSQL 8.1.1 should give you greater performance...
Indeed it has.
I am seeing a 25% increase in one particular select statement. This
increases to 32% with
set enable_bitmapscan to off;
I also ran a test script full of common SQL that the application runs.
I added some extra SQL to burst the cache a bit and I have managed to
get an average 14% increase.
I have not started tweaking things that much yet to take advantage of
the new parameters so I may yet see more of an increase but initial
indications are that the changes from 7.4.7 to 8.1.1 are significant.
The one thing that may be skewing these results is that this was
compiled and installed from source with
./configure CFLAGS='-O2' --with-openssl --enable-thread-safety
I am not sure what the default Debian binary for 7.4.7 is compiled
with so this may have had some affect.
--
Harry
http://www.hjackson.orghttp://www.uklug.co.uk
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-performance@postgresql.org
Cc: harryjackson@gmail.com
Subject: Re: PostgreSQL performance question.
In-Reply-To: <45b42ce40512171811r293e254ex94a4e69910f80466@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