Re: Strange query plan - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Strange query plan
Date
Msg-id dcc563d10808140814j4ede30ci5f2c15e7950fff9c@mail.gmail.com
Whole thread Raw
In response to Re: Strange query plan  ("Gauthier, Dave" <dave.gauthier@intel.com>)
List pgsql-general
On Thu, Aug 14, 2008 at 8:48 AM, Gauthier, Dave <dave.gauthier@intel.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.

pgsql-general by date:

Previous
From: Devrim GÜNDÜZ
Date:
Subject: Re: Newbie [CentOS 5.2] service postgresql initdb
Next
From: Artacus
Date:
Subject: Custom sort