> opensims=#
>
> I'd really like to avoid putting a 'set enable_seqscan=false' in my
> code, especially since this query only has a problem if it's run on a
> large date/time window, which normally doesn't happen.
Try increasing your statistics target for the column and then rerunning
analyze.
Sincerely,
Joshua D. Drake
--
Command Prompt, Inc., home of PostgreSQL Replication, and plPHP.
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
Mammoth PostgreSQL Replicator. Integrated Replication for PostgreSQL