Re: Is Synchronous Postgresql Replication Slower Than Asynchronous?
| От | Stuart Bishop |
|---|---|
| Тема | Re: Is Synchronous Postgresql Replication Slower Than Asynchronous? |
| Дата | |
| Msg-id | CADmi=6Pxe9-wKojJOcXETRoHMqyYf2DPzvJN6hzzsir6NbYs4w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Is Synchronous Postgresql Replication Slower Than Asynchronous? (Simon Riggs <simon@2ndQuadrant.com>) |
| Ответы |
Re: Is Synchronous Postgresql Replication Slower Than Asynchronous?
|
| Список | pgsql-general |
On Mon, Jan 23, 2012 at 9:37 PM, Simon Riggs <simon@2ndquadrant.com> wrote: > On Mon, Jan 23, 2012 at 2:30 PM, Stuart Bishop <stuart@stuartbishop.net> wrote: >> On Sat, Jan 21, 2012 at 3:31 AM, Jerry Richards >> <jerry.richards@teotech.com> wrote: >>> Is synchronous postgresql replication slower than asynchronous? If so, how >>> much? I am looking into database replication for a phone system, so the >>> response time is of concern. >> >> You might want to investigate pgpool-ii. It sits as a proxy between >> the client and the databases, and as queries are executed >> simultaneously, a synchronous replication setup should be just as fast >> as an unreplicated setup. > > Can you share your actual results on that? No. This is based on my assumptions from the design, not from actual tests. I'm currently asynchronously replicated with Slony-I and looking at PG 9.1 builtin replication for our simpler clusters. -- Stuart Bishop <stuart@stuartbishop.net> http://www.stuartbishop.net/
В списке pgsql-general по дате отправления: