Re: Analyze not doing anything?

"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