Re: GUC-ify walsender MAX_SEND_SIZE constant

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: GUC-ify walsender MAX_SEND_SIZE constant
Дата
Msg-id
ZcliBT1AujeBvQQX@paquier.xyz
Ответ на
Список
Дерево обсуждения
GUC-ify walsender MAX_SEND_SIZE constant Majid Garoosi <amoomajid99@gmail.com>
Re: GUC-ify walsender MAX_SEND_SIZE constant Andres Freund <andres@anarazel.de>
Re: GUC-ify walsender MAX_SEND_SIZE constant Majid Garoosi <amoomajid99@gmail.com>
Re: GUC-ify walsender MAX_SEND_SIZE constant Michael Paquier <michael@paquier.xyz>
Re: GUC-ify walsender MAX_SEND_SIZE constant Majid Garoosi <amoomajid99@gmail.com>
Re: GUC-ify walsender MAX_SEND_SIZE constant Michael Paquier <michael@paquier.xyz>
Re: GUC-ify walsender MAX_SEND_SIZE constant Jakub Wartak <jakub.wartak@enterprisedb.com>
Re: GUC-ify walsender MAX_SEND_SIZE constant Andres Freund <andres@anarazel.de>
Re: GUC-ify walsender MAX_SEND_SIZE constant Jakub Wartak <jakub.wartak@enterprisedb.com>
Re: GUC-ify walsender MAX_SEND_SIZE constant Majid Garoosi <amoomajid99@gmail.com>
Re: GUC-ify walsender MAX_SEND_SIZE constant Michael Paquier <michael@paquier.xyz>
Re: GUC-ify walsender MAX_SEND_SIZE constant Michael Paquier <michael@paquier.xyz>
Re: GUC-ify walsender MAX_SEND_SIZE constant Majid Garoosi <amoomajid99@gmail.com>
Re: GUC-ify walsender MAX_SEND_SIZE constant Michael Paquier <michael@paquier.xyz>
Re: GUC-ify walsender MAX_SEND_SIZE constant Majid Garoosi <amoomajid99@gmail.com>
On Sun, Feb 11, 2024 at 04:32:20PM +0330, Majid Garoosi wrote:
> On Fri, 9 Feb 2024 at 22:33, Andres Freund  wrote:
>> The way we read the WAL data is perfectly prefetchable by the the OS, so I
>> wouldn't really expect gains here.  Have you actually been able to see a
>> performance benefit by increasing MAX_SEND_SIZE?
> 
> Yes, I have seen a huge performance jump. Take a look at here
> 
> for
> more info.

Yes, I can get the idea that grouping more replication messages in
one shot can be beneficial in some cases while being
environment-dependent, though I also get the point that we cannot
simply GUC-ify everything either.  I'm OK with this one at the end,
because it is not performance critical.

Note that it got lowered to the current value in ea5516081dcb to make
it more responsive, while being half a WAL segment in 40f908bdcdc7
when WAL senders have been introduced in 2010.  I cannot pinpoint the
exact thread that led to this change, but I'm adding Fujii-san and
Heikki in CC for comments.
--
Michael
В списке pgsql-hackers по дате отправления
От: jian he
Дата:
От: Ashutosh Bapat
Дата:
FAQ