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 Sam Mason <sam@samason.me.uk>
Re: How to use index in WHERE int = float Sam Mason <sam@samason.me.uk>
Re: How to use index in WHERE int = float "Andrus" <kobruleht2@hot.ee>
Re: How to use index in WHERE int = float "Scott Marlowe" <scott.marlowe@gmail.com>
Re: How to use index in WHERE int = float Sam Mason <sam@samason.me.uk>
Re: How to use index in WHERE int = float "Andrus" <kobruleht2@hot.ee>
Re: How to use index in WHERE int = float Sam Mason <sam@samason.me.uk>
Re: How to use index in WHERE int = float "Andrus" <kobruleht2@hot.ee>
Re: How to use index in WHERE int = float Sam Mason <sam@samason.me.uk>
Re: How to use index in WHERE int = float "Scott Marlowe" <scott.marlowe@gmail.com>
Re: How to use index in WHERE int = float "Andrus" <kobruleht2@hot.ee>
Re: How to use index in WHERE int = float Tom Lane <tgl@sss.pgh.pa.us>
Re: How to use index in WHERE int = float "Andrus" <kobruleht2@hot.ee>
Re: How to use index in WHERE int = float Tom Lane <tgl@sss.pgh.pa.us>
Re: How to use index in WHERE int = float "Andrus" <kobruleht2@hot.ee>
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 по дате отправления
