Home > mailing lists

Re: select ... where ='' does a seqscan [auf Viren geprueft] - Mailing list pgsql-general

From	Peter Eisentraut
Subject	Re: select ... where ='' does a seqscan [auf Viren geprueft]
Date	August 24, 2004 13:04:58
Msg-id	200408241504.40569.peter_e@gmx.net Whole thread Raw
In response to	select ... where ='' does a seqscan [auf Viren geprueft] (Silvio Matthes <silvio.matthes@xcom.de>)
List	pgsql-general

Tree view

Am Dienstag, 24. August 2004 11:59 schrieb Silvio Matthes:
> So using the index does need more time than a sequential scan?

It's possible.  If you want to prove the opposite, please post the output of
EXPLAIN ANALYZE in both cases.

--
Peter Eisentraut
http://developer.postgresql.org/~petere/

pgsql-general by date:

From: Secrétariat
Date: 24 August 2004, 11:54:03
Subject: Re: No connection to a PG 8.0 Beta 1 win32 server

From: "Eduardo S. Fontanetti"
Date: 24 August 2004, 13:40:34
Subject: Dump and Restore

Re: select ... where ='' does a seqscan [auf Viren geprueft] - Mailing list pgsql-general

Previous

Next