Query planner problem

From: "Crash Dummy" <crash(dot)dummy(at)ntlworld(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Query planner problem
Date: 2002-03-09 00:29:14
Message-ID: a6bko1$2u0l$1@jupiter.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Lockhart 2002-03-09 03:52:17 Re: decimal(5) vs int8. Which more efficient.
Previous Message Tom Lane 2002-03-09 00:24:45 Re: Is vacuum full lock like old's vacuum's lock?