This could be just about anything. Which OS are you running? Did you check any logs when everything went crazy?
Sorry, should have been more verbose.
OS is debian squeeze, pg installed is the latest 9.2.1 from pgapt.debian.net. Logs where checked, no errors/warnings at all. Query plans have been checked, no changes before/after. The changed behavior only manifested in the drop of the number of transactions/second executed and the massively increased load in the machine. No increased I/O or anything.
Since A has been promoted to master, everything behaves like expected, the 9.2 outperformes the 9.0 easily, as expected.
-- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
