Postgres Pro
Downloads
Home   >   mailing lists

Query planner problem - Mailing list pgsql-general

From Crash Dummy
Subject Query planner problem
Date
Msg-id a6bko1$2u0l$1@jupiter.hub.org
Whole thread Raw
Responses Re: Query planner problem  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Re: Query planner problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
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.

Cheers,

Bob

pgsql-general by date:

Previous
From: "Jacob Vennervald Madsen"
Date:
Subject: Re: Modifying text data?
Next
From: Doug McNaught
Date:
Subject: Re: Export a database or a table from a database