| From: | Nabil Sayegh <nsmail(at)sayegh(dot)de> |
|---|---|
| To: | ltt(at)pml(dot)ac(dot)uk |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Nested Queries |
| Date: | 2001-01-17 12:51:54 |
| Message-ID: | 3A65956A.91FF5262@sayegh.de |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
Luke Tudor - RSG wrote:
>
> Hi,
>
> I seem to have a small problem with my nested queries. Im sure its
> something so simple; If I run each query seperatly, I get the correct
> results and these results can be put into the parent query.
> However if the queries are run together as one nested query the results
> take
> hours and hours (more like days).
FAQ: 4.23) Why are my subqueries using IN so slow?
http://www.postgresql.org/docs/faq-english.html#4.23
(Use EXISTS instead of IN)
--
Nabil Sayegh
GPG-Key available at http://www.sayegh.de
(see http://www.gnupg.org for details)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Paul Joseph McGee | 2001-01-17 14:10:36 | Type Creation |
| Previous Message | John Poltorak | 2001-01-17 12:29:31 | Re: What am I doing wrong? |