| From: | Jean-Christian Imbeault <jc(at)mega-bucks(dot)co(dot)jp> |
|---|---|
| To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: IN vs EXIIST |
| Date: | 2002-09-19 13:46:27 |
| Message-ID: | 3D89D533.7000009@mega-bucks.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jochem van Dieten wrote:
>
> Sorry, not behind the console at the moment. Try either:
Ok :) I tried both new versions and they work great.
But ... they are not faster than the IN version. They run at exactly the
same speed.
Another thing is that the IN query and yours don't seem to be so
dependent on the DB having been vacuum analyzed while the query with the
EXISTS does (it goes from 15 secs to 5secs after vacuuming)
I guess using IN in this case is not making the query slow.
In case it's important the table contains 16800 rows and returns 300
matches.
I'll be sticking with my IN query ...
Jc
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Greg Copeland | 2002-09-19 13:47:14 | Re: [GENERAL] PGXLOG variable worthwhile? |
| Previous Message | Martijn van Oosterhout | 2002-09-19 13:40:20 | Re: NUMERIC and arithmetics |