Re: How to prioritise walsender reading from pg_wal over WAL writes?

2020-11-18 Thread Laurenz Albe
On Wed, 2020-11-18 at 12:15 +, Alexey Bashtanov wrote: > My reply did not get threaded appropriately. > My original question was here: > https://www.postgresql.org/message-id/a74d5732-60fd-d18b-05fd-7b2b97099f19%40imap.cc > I'd like to prioritize walsender for replication not to lag too much. >

Re: How to prioritise walsender reading from pg_wal over WAL writes?

2020-11-18 Thread Alexey Bashtanov
Sorry Laurenz, My reply did not get threaded appropriately. My original question was here: https://www.postgresql.org/message-id/a74d5732-60fd-d18b-05fd-7b2b97099f19%40imap.cc I'd like to prioritize walsender for replication not to lag too much. Otherwise, when I have load spikes on master, stand

Re: How to prioritise walsender reading from pg_wal over WAL writes?

2020-11-18 Thread Laurenz Albe
On Wed, 2020-11-18 at 11:54 +, Alexey Bashtanov wrote: > If it helps, here's the details of the hardware config. > The controller is AVAGO MegaRAID SAS 9361-4i, > the SSDs are INTEL SSDSC2KG960G8 (configured as a raid1). > Current scheduler used is deadline. > Currently XFS is mounted without n

Re: How to prioritise walsender reading from pg_wal over WAL writes?

2020-11-18 Thread Alexey Bashtanov
If it helps, here's the details of the hardware config. The controller is |AVAGO MegaRAID SAS 9361-4i|, the SSDs are |INTEL SSDSC2KG960G8| (configured as a raid1). Current scheduler used is deadline. Currently XFS is mounted without nobarriers, but I'm going to set that when there's high load nex