[GENERAL] Writing on replicas?

Поиск
Список
Период
Сортировка
От Ivan Voras
Тема [GENERAL] Writing on replicas?
Дата
Msg-id CAF-QHFXYrBUwUhEiFdXpMBSaagobuiu8hPeNaP46rRGNpi4rFg@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] Writing on replicas?  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Список pgsql-general
Hello,

I have a possibly unusual case, I've asked about it before on this list.

There is a bunch of reporting being done regularly on some large databases, which interfere with daily operations performance-wise. So one option is to have hot async replication in place to a secondary server where the reports could be run and not impact the main server.

The reporting code is *almost* read-only, with the major exception being that it creates temp tables for intermediate results. The main tables are not written to, just the temp tables.

Some time ago when I've asked what to do in this situation, the answer was that maybe a future version could allow this setup to work. So, I'm asking again: was something changed in 10.0 which would allow it?


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

Предыдущее
От: Jaime Soler
Дата:
Сообщение: Re: [GENERAL] Postgres 9.6 Logical and Fisical replication
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [GENERAL] Writing on replicas?