Still slow as mud: http://explain.depesz.com/s/Zfn
Now I've got indices on created, timezone, created at time zone timezone, and (created at time zone timezone)::date. Clearly the problem isn't a lack of indices!...except, wait, it's not actually using blocks_created_date_idx (or blocks_created_at_timezone_idx). How do I make that happen? On Thu, Feb 9, 2012 at 12:15 PM, Kevin Grittner <kevin.gritt...@wicourts.gov > wrote: > Alessandro Gagliardi <alessan...@path.com> wrote: > > > (Actually, I originally did try one on "(created at time zone > > timezone)::date" but couldn't figure out how to phrase it in a way > > PostgreSQL would accept.) > > CREATE INDEX blocks_created_date_idx > ON blocks > USING btree > (((created at time zone timezone)::date)); > > -Kevin >