| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Gregory Wood <gregw(at)com-stock(dot)com> |
| Cc: | PostgreSQL-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: 7.3 support for IN |
| Date: | 2002-07-19 00:52:02 |
| Message-ID: | 20020719105202.C10333@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jul 18, 2002 at 01:52:44PM -0400, Gregory Wood wrote:
> Before anyone starts thinking it, yes, I am aware that INs are really slow
> in PostgreSQL. That being said... I was doing some tests with big IN
> statements and various workarounds and was shocked at some of the results.
I hope those values were averaged out over a few runs. Measuring something as
16ms with a single run makes it statistically invalid. Maybe PostgreSQL
happened to lose it's timeslice just as the EXISTS query came along, blowing
any results completely out of the water.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> There are 10 kinds of people in the world, those that can do binary
> arithmetic and those that can't.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anthony Berglas | 2002-07-19 01:43:03 | Mulit-Vesions and Vacuum |
| Previous Message | Martijn van Oosterhout | 2002-07-19 00:41:31 | Re: select a ranking |