Thread

1. Subqueries?

   Aleksey Dashevsky <postgres@luckynet.co.il> — 1998-09-04T07:15:19Z

   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.
   
   
   

2. Re: [HACKERS] Subqueries?

   Vadim Mikheev <vadim@krs.ru> — 1998-09-04T07:55:34Z

   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
   
   

3. Re: [HACKERS] Subqueries?

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-09-04T14:22:48Z

   > 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)