strange behaviour - Mailing list pgsql-general

From mkennedy@hssinc.com (Matthew Kennedy)
Subject strange behaviour
Date
Msg-id 3A22A077.DF0DAE2B@opushealthcare.com
Whole thread Raw
List pgsql-general
I have a database with a bunch of large tables under postgres 7.0.2
which I've been  filling with many rows (order of millions). I have been
copying data into and deleting from frequently. Everything was great
until I upgraded to 7.0.3. Then trying to do _anything_ to that database
via psql caused the postmaster to ram the CPU at 100% indefinitely. I
downgraded to 7.0.2 but I still get this problem.

I know upgrading to 7.0.3 from 7.0.2 shouldn't require a dump/restore...
what could be causing this problem?

--
Matthew Kennedy

pgsql-general by date:

Previous
From: "Nick Fankhauser"
Date:
Subject: How to keep Postgres from thrashing for a long time using "LIMIT" (or is there a better way?)!
Next
From: Nelio Alves Pereira Filho
Date:
Subject: Re: Trigger question