Re: Very slow queries - please help.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bealach-na Bo" <bealach_na_bo(at)hotmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Very slow queries - please help.
Date: 2005-11-24 15:15:35
Message-ID: 13626.1132845335@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Bealach-na Bo" <bealach_na_bo(at)hotmail(dot)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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-11-24 15:37:21 Re: xlog flush request error
Previous Message Guillaume Smet 2005-11-24 15:03:47 Re: Very slow queries - please help.