John Siracusa <[EMAIL PROTECTED]> writes:
> I think the key is to get the planner to correctly ballpark the number of
> rows in the date range.

I thought it was.  What you showed was

-> Index Scan using mytable_date_idx on mytable (cost=0.00..3071.70 rows=52155 
width=23) (actual time=2.610..1688.111 rows=49679 loops=1)

which seemed plenty close enough to me.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org

Reply via email to