Andre,
I'm not even going to try to deal with the seq_scan vs. index_scan
issues on now(). This has been brought up in the list archives. Test
your actual response times as well as the query plan; you may find that
you don't have a real problem.
Something I can help you with:
> explain select * from test_table where date_trunc('month',time_stamp)
> = date_trunc('month',datetime('2002-01-01'));
> NOTICE: QUERY PLAN:
>
> Seq Scan on test_table (cost=0.00..2441.41 rows=584 width=16)
Try doing a:
CREATE INDEX idx_test_month ON test_table(extract(month FROM
time_stamp));
Which should help.
-Josh
