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
regards, tom lane
In response to
pgsql-bugs by date
|Next:||From: jeff||Date: 2011-01-18 11:19:07|
|Subject: Re: BUG #5841: rank()+1 fails, 1+rank() succeeds|
|Previous:||From: Tim Uckun||Date: 2011-01-18 00:19:17|
|Subject: Re: Problems with adding a is not null to a query.|