Search Postgresql Archives

Re: Failure to use indexes (fwd)

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
>

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux