Re: [PERFORM] Speed differences between in executing the same query

Thank you very much Tom. This is very helpful. -- View this message in context: http://www.postgresql-archive.org/Speed-differences-between-in-executing-the-same-query-tp5960964p5961041.html Sent from the PostgreSQL - performance mailing list archive at Nabble.com. -- Sent via pgsql-performa

[PERFORM] Speed differences between in executing the same query

I have a weird case of query execution performance here. The query has a date values in the WHERE clause, and the speed of executing varies by values of the date. Actualy, - for the dates from the range of the last 30 days execution takes aruond 3 min - for the dates before the range of the las