Postgres Pro
Downloads
Home   >   mailing lists

Re: Analyze not doing anything? - Mailing list pgsql-general

From Tom Lane
Subject Re: Analyze not doing anything?
Date
Msg-id 7011.1076012596@sss.pgh.pa.us
Whole thread Raw
In response to Analyze not doing anything?  ("Jim C. Nasby" <jim@nasby.net>)
Responses Re: Analyze not doing anything?  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-general
Tree view 
"Jim C. Nasby" <jim@nasby.net> writes:
> I build a table to test the theory that PGSQL wouldn't use an index to
> satisfy 'SELECT * FROM table WHERE field IS NOT NULL'.

IS NULL/IS NOT NULL are not indexable operators.

            regards, tom lane

pgsql-general by date:

Previous
From: Joe Conway
Date:
Subject: Re: dblink: rollback transaction
Next
From: Alvaro Herrera
Date:
Subject: Re: functional index "real world" uses