Re: Performance problems on a fairly big table with two

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Performance problems on a fairly big table with two
Дата
Msg-id 200309051739.32467.dev@archonet.com
обсуждение исходный текст
Ответ на Re: Performance problems on a fairly big table with two  ("Rasmus Aveskogh" <rasmus@defero.se>)
Список pgsql-performance
Дерево обсуждения 
On Friday 05 September 2003 16:36, Rasmus Aveskogh wrote:
> Richard,
>
> Thanks a lot! You were right - the query parser "misunderstood"
> now() - '1 day'::interval and only used one of the indexes (as I already
> noticed).
>
> Actually all I had to do was to cast the result like this:
>
> (now() - '1 day'::interval)::date
>
> 75s is not between 10ms and 200ms.
>
> Thanks again!

Ah - good. You also want to be careful with differences between timestamp
with/without time zone etc.
--
  Richard Huxton
  Archonet Ltd

В списке pgsql-performance по дате отправления:

Предыдущее
От: Ron Johnson
Дата:
Сообщение: Re: [GENERAL] Seq scan of table?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [GENERAL] how to get accurate values in pg_statistic (continued)