Re: Receive buffer size for the statistics socket

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Receive buffer size for the statistics socket
Date: 2017-05-30 00:14:55
Message-ID: 12781.1496103295@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

I wrote:
>> I propose that it'd be a good idea to try to set the stats socket's
>> receive buffer size to be a minimum of, say, 100K on all platforms.
>> Code for this would be analogous to what we already have in pqcomm.c
>> (circa line 760) for forcing up the send buffer size, but SO_RCVBUF
>> not SO_SNDBUF.

> I propose committing this (less the debug logging part) to HEAD
> once the beta is out, and then back-patching if it doesn't break
> anything and seems to improve matters on frogmouth.

That went in in 8b0b6303e. frogmouth had failed in 5 of the 23 HEAD runs
it made between 4e37b3e15 and 8b0b6303e. Since then, it has shown zero
failures in 50 runs. I don't know what confidence a statistician would
assign to the proposition that 8b0b6303e improved things, but this is good
enough for me. I'm going to go back-patch it.

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2017-05-30 01:02:53 Fix GetOldestXmin comment
Previous Message Tom Lane 2017-05-29 23:31:45 Re: PATCH: recursive json_populate_record()