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@svana.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.