Re: strange hot_standby behaviour

From: Andreas Pfotenhauer <pfote(at)ypsilon(dot)net>
To: pgsql-general(at)postgresql(dot)org
Cc: Lonni J Friedman <netllama(at)gmail(dot)com>
Subject: Re: strange hot_standby behaviour
Date: 2012-10-01 17:43:42
Message-ID: 5069D64E.7040700@ypsilon.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Hastie 2012-10-01 17:48:40 Re: pg_upgrade: out of memory
Previous Message Shaun Thomas 2012-10-01 17:26:35 Re: Securing .pgpass File?