Re: LIMIT causes planner to do Index Scan using a less optimal index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Tue, Apr 6, 2010 at 6:30 PM, Joel Jacobson <joel@xxxxxxxxxxxxxxx> wrote:
Actually, swapping the order of the conditions did in fact make some difference, strange.

I ran the query a couple of times for each variation to see if the difference in speed was just a coincidence or a pattern. Looks like the speed really is different.

Wow.  That's very surprising to me...

...Robert

[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux