| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Adam Rich <adam(dot)r(at)sbcglobal(dot)net> |
| Cc: | 'askel' <dummy666(at)mail(dot)ru>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: IN vs EXISTS |
| Date: | 2008-06-12 17:14:47 |
| Message-ID: | 1213290887.3235.3.camel@dogma.ljc.laika.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Sat, 2008-06-07 at 08:59 -0500, Adam Rich wrote:
> what's faster on one dbms my be different than another. I've found
> that postgresql is usually slower than other databases for IN ()
> queries, but handles EXISTS and inner joins (a third way of writing
> your queries above) quite quickly.
Do you have an explanation for the slow IN performance? Do you mean
Postgres is slow with a value list or a subquery or both? Is it because
the execution of a particular plan is slow, or does some good plan not
exist in Postgres?
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Terry Yapt | 2008-06-12 17:21:51 | Win32 8.3.3 install fail (sufficient privileges to install system services). |
| Previous Message | Raymond O'Donnell | 2008-06-12 17:13:14 | Re: defining a variable |