Re: Failure to use indexes (fwd) - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Failure to use indexes (fwd)
Date
Msg-id 1123017729.21793.46.camel@state.g2switchworks.com
Whole thread Raw
In response to Re: Failure to use indexes (fwd)  (Dr NoName <spamacct11@yahoo.com>)
Responses Re: Failure to use indexes (fwd)  (Edmund Dengler <edmundd@eSentire.com>)
List 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.

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Slow Inserts on 1 table?
Next
From: Tom Lane
Date:
Subject: Re: feeding big script to psql