Re: Synchronous replication
От
Thomas Munro
Тема
Re: Synchronous replication
Дата
Msg-id
CAEepm=1Q7_3ac9zQ3moA==COeAOpKOtC0RgdeO6S21HKzbizuw@mail.gmail.com
Ответ на
Re: Synchronous replication (Joshua D. Drake)
Список
Дерево обсуждения
Synchronous replication jwiencek3@comcast.net
Re: Synchronous replication "Joshua D. Drake" <jd@commandprompt.com>
Re: Synchronous replication Thomas Munro <thomas.munro@enterprisedb.com>
Re: Synchronous replication John Wiencek <jwiencek3@comcast.net>
On Thu, Jan 14, 2016 at 9:34 AM, Joshua D. Drake wrote: > On 01/13/2016 12:28 PM, jwiencek3@comcast.net wrote: >> >> Is it possible to set up synchronous replication to more that one node >> in a cluster? Or, am I limited to one synchronous node and one >> asynchronous node? > > > Yes you can have N number of synchronous slaves. However, be careful. It can > be a huge performance hit. Note that only one of the listed standbys is a synchronous standby at any given time though. That is, when you commit, the primary server will wait just for that one server to report that it has fsync'ed the WAL. (There is a patch being developed to change that so that you might be able to wait for more than one in a future release). -- Thomas Munro http://www.enterprisedb.com
В списке pgsql-general по дате отправления
От: Andreas Joseph Krogh
Дата:
