Tim Uckun <timuckun(at)gmail(dot)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