From: John Arbash Meinel <john@arbash-meinel.com>
To: Miroslav Šulc <miroslav.sulc@startnet.cz>
Cc: PGSQL mailing list <pgsql-performance@postgresql.org>
Subject: Re: How to read query plan
Date: Sun, 13 Mar 2005 11:30:25 -0600
Message-ID: <423478B1.7080106@arbash-meinel.com> (raw)
In-Reply-To: <42347407.2000202@startnet.cz>
References: <42345D24.8070104@startnet.cz>
<4234692E.3050802@arbash-meinel.com>
<42347407.2000202@startnet.cz>
Miroslav Šulc wrote:
> Hi John,
>
> thank you for your response.
>
How about a quick side track.
Have you played around with your shared_buffers, maintenance_work_mem,
and work_mem settings?
What version of postgres are you using? The above names changed in 8.0,
and 8.0 also has some perfomance improvements over the 7.4 series.
What is your hardware? Are you testing this while there is load on the
system, or under no load.
Are you re-running the query multiple times, and reporting the later
speeds, or just the first time? (If nothing is loaded into memory, the
first run is easily 10x slower than later ones.)
Just some background info. If you have set these to reasonable values,
we probably don't need to spend much time here, but it's just one of
those things to check.
John
=:->
Attachments:
signature.asc (application/pgp-signature, 252B) download
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: john@arbash-meinel.com, miroslav.sulc@startnet.cz
Subject: Re: How to read query plan
In-Reply-To: <423478B1.7080106@arbash-meinel.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