Postgres Pro
Downloads
Home   >   mailing lists

Re: Not using Primary Key in query - Mailing list pgsql-performance

From Tom Lane
Subject Re: Not using Primary Key in query
Date
Msg-id 15004.1085807165@sss.pgh.pa.us
Whole thread Raw
In response to Not using Primary Key in query  (Josh Sacks <josh.sacks@gmail.com>)
List pgsql-performance
Tree view 
Josh Sacks <josh.sacks@gmail.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

pgsql-performance by date:

Previous
From: share-postgres@think42.com
Date:
Subject: Re: filesystem option tuning
Next
From: "rajaguru"
Date:
Subject: Logging all query in one seperate File