Re: [PERFORM] Weird case of wrong index choice

2013-09-03 Thread Claudio Freire
On Tue, Sep 3, 2013 at 8:11 PM, Tom Lane wrote: > Claudio Freire writes: >> So, I've got this query with this very wrong plan: > >> explain SELECT min(created) < ((date_trunc('day',now()) - '90 >> days'::interval)) FROM "aggregated_tracks_daily_full" WHERE id BETWEEN >> 34979048 AND 35179048 >> ;

Re: [PERFORM] Weird case of wrong index choice

2013-09-03 Thread Tom Lane
Claudio Freire writes: > So, I've got this query with this very wrong plan: > explain SELECT min(created) < ((date_trunc('day',now()) - '90 > days'::interval)) FROM "aggregated_tracks_daily_full" WHERE id BETWEEN > 34979048 AND 35179048 > ; > QUERY PLAN >