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 :-(

Thanky you
Aleksey.


Fri, 4 Sep 1998 10:15:19 +0300 (IDT)
Aleksey Dashevsky <postgres@luckynet.co.il>
Subqueries?
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

Fri, 04 Sep 1998 15:55:34 +0800
Vadim Mikheev <vadim@krs.ru>
Re: [HACKERS] Subqueries?
> 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 :-(
> 

This is the first report of subquery slowness I have heard.  We have
fixed a problem where using an oid in the subquery caused a loop, but
other than that, everything seems fine.  How about sending us some
queries that are slow, and perhaps we can suggest something.


-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)

Fri, 4 Sep 1998 10:22:48 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Subqueries?