Re: Failure to use indexes (fwd)

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Dr NoName <spamacct11(at)yahoo(dot)com>
Cc: Edmund Dengler <edmundd(at)eSentire(dot)com>, Postgresql-General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Failure to use indexes (fwd)
Date: 2005-08-02 21:22:09
Message-ID: 1123017729.21793.46.camel@state.g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2005-08-02 at 16:06, Dr NoName wrote:
> The solution to my problem was to increase statistics
> value and do another analyze. You can also change
> default_statistics_target parameter in
> postgresql.conf. Don't know if that's related to the
> problem you're seeing, but it's worth a try.

Cool postgresql trick:

alter database test set default_statistics_target=200;

You can change the default for a databases's new tables too.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2005-08-02 21:44:30 Re: feeding big script to psql
Previous Message Scott Marlowe 2005-08-02 21:11:33 Re: Slow Inserts on 1 table?