Re: Query planner problem

Crash Dummy wrote:
> Hi,
>
> I've moved a database onto a much faster machine but for some reason the
> query planner is opting to use seq scan methods rather than the indexes.
>
> This is a very large database without the indexes the performance is dire -
> the new machine is a 2Ghz P4 with 1GB RAM, the old machine is a 900Mhz P3
> with 512Mb Ram.
>
> Any idea why this is happening adn what I can do to solve the problem ? I've
> tried dropping & rebuilding the indexes, vacuum analyze etc but to no
> effect.

Read the current FAQ item 4.8 on the web site. It is more current and
should answer your question.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026