Re: selecting records from a date range - Mailing list pgsql-sql

From Tom Lane
Subject Re: selecting records from a date range
Date
Msg-id 19563.1017711824@sss.pgh.pa.us
Whole thread Raw
In response to selecting records from a date range  ("Dan Langille" <dan@langille.org>)
Responses Re: selecting records from a date range  ("Dan Langille" <dan@langille.org>)
List pgsql-sql
"Dan Langille" <dan@langille.org> writes:
> I'm having fun with this one.  It was nice and fast before the vacuum, but 
> very 
> slow afterwards.  The idea is to get all the records for a given day.

[ scratches head... ]  I tried to reproduce this, but for me it still
seems to prefer nestloop.  Have you been playing any games with the
planner cost parameters?  What does pg_stats show for these tables?
        regards, tom lane


pgsql-sql by date:

Previous
From: "Dan Langille"
Date:
Subject: selecting records from a date range
Next
From: "Dan Langille"
Date:
Subject: Re: selecting records from a date range