Re: Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ? - Mailing list pgsql-general

From Tom Lane
Subject Re: Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?
Date
Msg-id 9426.1388761242@sss.pgh.pa.us
Whole thread Raw
In response to Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?  (xbzhang <xbzhang@kingbase.com.cn>)
Responses Re: Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-general
xbzhang <xbzhang@kingbase.com.cn> writes:
> Why the size (PQ_BUFFER_SIZE) of backend send buffers  is 8192 ?

Traditionally, at least, that was the size of pipe buffers in Unix
machines, so in principle this is the most optimal chunk size for
sending data across a Unix socket.  I have no idea though if that's
still true in kernels in common use today.  For TCP communication
it might be marginally better to find out the MTU size and use that;
but it's unclear that it's worth the trouble, or indeed that we can
know the end-to-end MTU size with any reliability.

            regards, tom lane


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: authentication failure
Next
From: Tom Lane
Date:
Subject: Re: authentication failure