David,
> The problem: Doing a query for a date range on a particular store or
> market, though, for a date range of more than a few days does a
> sequential scan of sales_tickets, and performs worse than doing one
> single date query for each date. My 'explain' for one such query is
> below.
Can you run EXPLAIN ANALYZE instead of just EXPLAIN? That will show you the
discrepancy between estimated and actual costs, and probably show you what
needs fixing.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco