Re: query planner not using the correct index

From: "Joshua Shanks" <jjshanks(at)gmail(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "Craig Ringer" <craig(at)postnewspapers(dot)com(dot)au>, pgsql-performance(at)postgresql(dot)org
Subject: Re: query planner not using the correct index
Date: 2008-08-08 14:28:44
Message-ID: 84f0acdb0808080728m1807f4dahe369500bbc04c248@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Joshua Shanks" <jjshanks(at)gmail(dot)com> writes:
>> How do I increase the stats target for just one column?
>
> Look under ALTER TABLE.
>
> regards, tom lane
>

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Luke Lonergan 2008-08-08 14:53:33 Re: Filesystem benchmarking for pg 8.3.3 server
Previous Message Henrik 2008-08-08 14:23:55 Filesystem benchmarking for pg 8.3.3 server