Re: timestamp with time zone

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(dot)Grittner(at)wicourts(dot)gov
> wrote:

> Alessandro Gagliardi <alessandro(at)path(dot)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
>