Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: select ... where ='' does a seqscan [auf Viren geprueft]
Date
Msg-id 4124.1093361738@sss.pgh.pa.us
Whole thread Raw
In response to select ... where ='' does a seqscan [auf Viren geprueft]  (Silvio Matthes <silvio.matthes@xcom.de>)
Responses Re: select ... where ='' does a seqscan [auf Viren  (Silvio Matthes <silvio.matthes@xcom.de>)
List pgsql-general
Tree view 
Silvio Matthes <silvio.matthes@xcom.de> writes:
> I try to select the rows of a table where the content of a varchar-column
> is empty ('') and PostgresQL is doing a seqscan.

If there are a very large number of rows with param_value='', it's
entirely possible that using an index to find them is counterproductive.

            regards, tom lane

pgsql-general by date:

Previous
From: Paul Thomas
Date:
Subject: Re: Dump and Restore
Next
From: "Thilina Gunasekara"
Date:
Subject: Re: [ADMIN] Dump and Restore