Re: [ADMIN] Autovacuum issues with truncate and create index ...

2012-12-31 Thread Baptiste LHOSTE
Hi, > Thanks. I wasn't suggesting you increase the duration; I just > wanted perspective on whether it could be the result of unusually > long run times rather than blocking, and how severe that increase > was known ot be. > Thank you very much, With that much information we should be much > bett

Re: [ADMIN] Autovacuum issues with truncate and create index ...

2012-12-31 Thread Kevin Grittner
Baptiste LHOSTE wrote: > These queries are very simple : delete from table where > start_date < availableTimestamp. We performed an EXPLAIN to try > to understand what could be the problem. The query planner said > that the index on start_date could not be used because it was not > up-to-date. Co