Re: Problems with adding a is not null to a query.

Tim Uckun <timuckun@gmail.com> writes:
>> As I've stated repeatedly, your next move needs to be to increase the
>> stats target, at least for that column if not globally.

> Ok How do I go about doing this.

If you want to do it globally for the whole database: change
default_statistics_target in postgresql.conf.  If you just want to
affect the one column, use "ALTER TABLE tab ALTER COLUMN col SET
STATISTICS n".

            regards, tom lane