Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Subqueries? - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: [HACKERS] Subqueries?
Date
Msg-id 35EF9CF6.B022089A@krs.ru
Whole thread Raw
In response to Subqueries?  (Aleksey Dashevsky <postgres@luckynet.co.il>)
List pgsql-hackers
Tree view 
Aleksey Dashevsky wrote:
>
> hi, hackers!
> do you plan some improvments on subqueries?
> Unfortunately, in v6.3.2 they often works very slowly, and thus
> are useful only on quite small tables :-(

Nothing...
If you use IN then try to rewrite your queries with EXISTS
if possible...

Vadim

pgsql-hackers by date:

Previous
From: Tom Ivar Helbekkmo
Date:
Subject: CIDR/IP types. Was: [GENERAL] big numbers
Next
From: Metin Ozsavran
Date:
Subject: Can PostgreSQL answer near-real-time demands?