From: | Edmund Dengler <edmundd(at)eSentire(dot)com> |
---|---|
To: | Scott Marlowe <smarlowe(at)g2switchworks(dot)com> |
Cc: | Dr NoName <spamacct11(at)yahoo(dot)com>, Postgresql-General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Failure to use indexes (fwd) |
Date: | 2005-08-02 21:52:25 |
Message-ID: | Pine.BSO.4.58.0508021751000.15363@cyclops4.esentire.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Greetings!
I have already increased the stats from 10 to 100. In addition, if I
specify individual tables, then the indexes are used. However, when I go
through the <inherits>, then indexes are not used. I will try and expand
the statistics, but suspect it is not the root cause of the problem.
Regards!
Ed
On Tue, 2 Aug 2005, Scott Marlowe wrote:
> 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.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
From | Date | Subject | |
---|---|---|---|
Next Message | Mohan, Ross | 2005-08-02 22:30:30 | Re: indexes are farked |
Previous Message | Tom Lane | 2005-08-02 21:44:30 | Re: feeding big script to psql |