> 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.
Aglio Database Solutions
In response to
pgsql-performance by date
|Next:||From: Richard Huxton||Date: 2004-01-21 20:38:22|
|Subject: Re: Queries with timestamps|
|Previous:||From: Bruno Wolff III||Date: 2004-01-21 18:36:56|
|Subject: Re: ORDER BY and LIMIT with SubSelects|