Re: strange hot_standby behaviour - Mailing list pgsql-general

From Andreas Pfotenhauer
Subject Re: strange hot_standby behaviour
Date
Msg-id 5069D64E.7040700@ypsilon.net
Whole thread Raw
In response to Re: strange hot_standby behaviour  (Lonni J Friedman <netllama@gmail.com>)
Responses Re: strange hot_standby behaviour  (Jan Nielsen <jan.sture.nielsen@gmail.com>)
List pgsql-general
> 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.


pgsql-general by date:

Previous
From: Shaun Thomas
Date:
Subject: Re: Securing .pgpass File?
Next
From: Andrew Hastie
Date:
Subject: Re: pg_upgrade: out of memory