Re: LIMIT causes planner to do Index Scan using a less optimal index - Mailing list pgsql-performance

From Robert Haas
Subject Re: LIMIT causes planner to do Index Scan using a less optimal index
Date
Msg-id n2g603c8f071004061722ja3a5d32x2e9738eb402b19d0@mail.gmail.com
Whole thread Raw
List pgsql-performance
On Tue, Apr 6, 2010 at 6:30 PM, Joel Jacobson <joel@gluefinance.com> 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

pgsql-performance by date:

Previous
From: Samuel Gendler
Date:
Subject: indexes in partitioned tables - again
Next
From: Craig Ringer
Date:
Subject: Re: query slow; strace output worrisome