From: Richard Huxton <dev@archonet.com>
To: Aaron Bono <postgresql@aranya.com>
Cc: PostgreSQL SQL List <pgsql-sql@postgresql.org>
Subject: Re: Query Join Performance
Date: Wed, 25 Apr 2007 18:59:48 +0100
Message-ID: <462F9714.8090802@archonet.com> (raw)
In-Reply-To: <bf05e51c0704241826u3e6652d1m26973b837e0b1397@mail.gmail.com>
References: <bf05e51c0704241826u3e6652d1m26973b837e0b1397@mail.gmail.com>
Aaron Bono wrote:
> Performance tanks with this query - it takes over 120 seconds (that is
> where
> I set the timeout).
> BTW, on our Linux box the full query we run (which adds 3 more tables on
> the
> whole operation along with more filtering on the zip table) finishes in
> under 10 seconds. Problem is our development is on Windows and this is a
> real pain for developers to test.
So what's different between the systems. Obvious things to look at:
1. EXPLAIN ANALYSE outputs to show the plans (these presumably are
different, but in what details, and why?)
2. Configuration (particularly memory/cost settings).
3. Hardware.
4. Locale/encoding - these can affect index usage and sorting.
--
Richard Huxton
Archonet Ltd
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-sql@postgresql.org
Cc: dev@archonet.com, postgresql@aranya.com
Subject: Re: Query Join Performance
In-Reply-To: <462F9714.8090802@archonet.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