Re: Strange query plan

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Gauthier, Dave" <dave(dot)gauthier(at)intel(dot)com>
Cc: "Dmitry Teslenko" <dteslenko(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Strange query plan
Date: 2008-08-14 15:14:12
Message-ID: dcc563d10808140814j4ede30ci5f2c15e7950fff9c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 14, 2008 at 8:48 AM, Gauthier, Dave <dave(dot)gauthier(at)intel(dot)com> wrote:
> Try this...
>
> Set default_statistics_target to be 1000 in postgres.conf then reboot
> your pg server. "Analyze" the table. Try the query again.

A reload is enough. I think you might have to disconnect and
reconnect your client, but I'm not sure.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Artacus 2008-08-14 17:22:37 Custom sort
Previous Message Devrim GÜNDÜZ 2008-08-14 15:11:05 Re: Newbie [CentOS 5.2] service postgresql initdb