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 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster