Re: How to use index in WHERE int = float

Поиск
Список
Период
Сортировка
От Sam Mason
Тема Re: How to use index in WHERE int = float
Дата
Msg-id 20081105210751.GW2459@frubble.xen.chris-lamb.co.uk
обсуждение исходный текст
Ответ на How to use index in WHERE int = float  ("Andrus" <kobruleht2@hot.ee>)
Ответы Re: How to use index in WHERE int = float  ("Andrus" <kobruleht2@hot.ee>)
Список pgsql-general
On Wed, Nov 05, 2008 at 08:52:50PM +0200, Andrus wrote:
> explain analyze select * from firma2.dok where  dokumnr='1228137'::float8
>
> "Seq Scan on dok  (cost=0.00..187766.23 rows=6255 width=1145) (actual
> time=43168.460..43176.063 rows=1 loops=1)"
> "  Filter: ((dokumnr)::double precision = 1228137::double precision)"
> "Total runtime: 43176.375 ms"

I've just noticed that "actual time" doesn't run from zero; is this part
of another query, or is something else going on?


  Sam

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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Debugging infrequent pegged out CPU usage
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: How to use index in WHERE int = float