Re: Not using Primary Key in query

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Josh Sacks <josh(dot)sacks(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Not using Primary Key in query
Date: 2004-05-29 05:06:05
Message-ID: 15004.1085807165@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Josh Sacks <josh(dot)sacks(at)gmail(dot)com> writes:
> I can't understand what's going on in this simple query:

If you are using anything older than PG 7.4, you should not expect good
performance from WHERE ... IN (sub-SELECT) queries. There's essentially
no optimization happening there.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message rajaguru 2004-05-29 06:28:35 Logging all query in one seperate File
Previous Message Bjoern Metzdorf 2004-05-28 10:43:11 Re: Hardware opinions wanted