Re: timestamp with time zone
| От | Alessandro Gagliardi |
|---|---|
| Тема | Re: timestamp with time zone |
| Дата | |
| Msg-id | CAAB3BBJyVqQQKqDZSz3ankPuT0PcsNxfC6U_GaPCCLDVWBRpzA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: timestamp with time zone ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>) |
| Ответы |
Re: timestamp with time zone
|
| Список | pgsql-performance |
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@wicourts.gov> wrote:
Alessandro Gagliardi <alessandro@path.com> wrote:CREATE INDEX blocks_created_date_idx
> (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.)
ON blocks
USING btree
(((created at time zone timezone)::date));
-Kevin
В списке pgsql-performance по дате отправления: