Re: query planner not using the correct index - Mailing list pgsql-performance

Just for closure I ended up doing

ALTER TABLE bars ALTER COLUMN bars_id SET STATISTICS 500;

On Thu, Aug 7, 2008 at 7:11 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Joshua Shanks" <jjshanks@gmail.com> writes:
>> How do I increase the stats target for just one column?
>
> Look under ALTER TABLE.
>
>                        regards, tom lane
>