RE: how to slow down parts of Pg

From: Kevin Brannen <KBrannen(at)efji(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: RE: how to slow down parts of Pg
Date: 2020-04-23 21:34:01
Message-ID: SA0PR19MB4255B9B291AB8A17AED5FD01A4D30@SA0PR19MB4255.namprd19.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>From: Ron <ronljohnsonjr(at)gmail(dot)com>
>
>What you need is async replication instead of synchronous replication.

The only way I can think of to do that in our present situation would be to
buy DRBD-Proxy, which becomes a single-point-of-failure and goes against the
idea of HA (it seems like a good product for disaster recovery but that's not
the goal). In addition, since we're trying to move away from DRBD and go to
WAL streaming, that doesn't seem like the best use of time and money. :)

If you'd like to expound on other ways/tools to do that, I'd love to hear about it,
although this might be better off-list.

Thanks,
Kevin
This e-mail transmission, and any documents, files or previous e-mail messages attached to it, may contain confidential information. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, distribution, review, copy or use of any of the information contained in or attached to this message is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify us by reply e-mail, and destroy the original transmission and its attachments without reading them or saving them to disk. Thank you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2020-04-23 21:36:19 Re: Fw: Re: Could Not Connect To Server
Previous Message David G. Johnston 2020-04-23 21:31:19 Re: Ned to understand why all the idle connections