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