Re: strange hot_standby behaviour

Поиск
Список
Период
Сортировка
От Jan Nielsen
Тема Re: strange hot_standby behaviour
Дата
Msg-id CANxH4hFHUjJwCjWrsKUMBoBLeJ-BYxS+12jNtvBuwQ3gKfbwOw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: strange hot_standby behaviour  (Andreas Pfotenhauer <pfote@ypsilon.net>)
Список pgsql-general
On Mon, Oct 1, 2012 at 11:43 AM, Andreas Pfotenhauer <pfote@ypsilon.net> wrote:
> 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.

It's not clear to me from your description if you're using stock PG
Hot Standby but, if you are, there is no support for Hot Standby
between different versions of PG; see the "What Can't You Do With
Binary Replication" section in the Binary Replication Tutorial on the
PG wiki [1].

[1] http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial#Hot_Standby


В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: 'full_page_writes=off' , VACUUM and crashing streaming slaves...
Следующее
От: Sean Chittenden
Дата:
Сообщение: Re: 'full_page_writes=off' , VACUUM and crashing streaming slaves...