Re: Queries with timestamps

Arnau,

>     As the number of rows grows the time needed to execute this query takes
> longer.  What'd I should do improve the performance of this query?

Tip #1)  add an index to the timestamp column
Tip #2) make sure that you VACUUM and ANALYZE regularly
Tip #3) You will get better performance if you pass the "current_date - 1
month" as a constant from the client instead of in the query.   This is a
known issue, expected to be fixed in 7.5.

--
-Josh Berkus
 Aglio Database Solutions
 San Francisco