From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bealach-na Bo <bealach_na_bo@hotmail.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Very slow queries - please help.
Date: Thu, 24 Nov 2005 10:15:35 -0500
Message-ID: <13626.1132845335@sss.pgh.pa.us> (raw)
In-Reply-To: <BAY101-F89F00F81CBAF5B66A6EE0AD540@phx.gbl>
References: <BAY101-F89F00F81CBAF5B66A6EE0AD540@phx.gbl>
"Bealach-na Bo" <bealach_na_bo@hotmail.com> writes:
> I'm having great difficulties getting the performance I had hoped for
> from Postgresql 8.0. The typical query below takes ~20 minutes !!
You need to show us the table definition (including indexes) and the
EXPLAIN ANALYZE results for the query.
It seems likely that the NOT IN is the source of your problems,
but it's hard to be sure without EXPLAIN results.
regards, tom lane
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: tgl@sss.pgh.pa.us, bealach_na_bo@hotmail.com
Subject: Re: Very slow queries - please help.
In-Reply-To: <13626.1132845335@sss.pgh.pa.us>
* 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