Silvio Matthes <silvio(dot)matthes(at)xcom(dot)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

In response to

• select ... where <column>='' does a seqscan [auf Viren geprueft] at 2004-08-24 09:59:45 from Silvio Matthes

Responses

• Re: select ... where <column>='' does a seqscan [auf Viren at 2004-08-24 16:34:03 from Silvio Matthes

pgsql-general by date

Next:	From: Thilina Gunasekara	Date: 2004-08-24 15:38:19
	Subject: Re: [GENERAL] Dump and Restore
Previous:	From: Paul Thomas	Date: 2004-08-24 15:29:56
	Subject: Re: [GENERAL] Dump and Restore