Re: timestamp with time zone

[Alessandro Gagliardi <alessandro@xxxxxxxx>]

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.Grittner@xxxxxxxxxxxx> wrote:

Alessandro Gagliardi <alessandro@xxxxxxxx> 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