[GENERAL] Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?

2014-01-03 Thread xbzhang
Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ? Can i set it to other value ? If i extend or decrease it , can it affect the performance of sending message? 张晓博 研发二部 北京人大金仓信息技术股份有限公司 地址:北京市海淀区上地西路八号院上地科技大厦4号楼501 邮编:100085 电话:(010) 5885 1118 - 8450 手机:15311394463

Re: [GENERAL] Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?

2014-01-03 Thread Giuseppe Broccolo
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Il 03/01/2014 09:47, xbzhang ha scritto: Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ? Can i set it to other value ? In principle, it is just an arbitrary amount by which to increase the I/O buffer size. Of course it has to

Re: [GENERAL] Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?

2014-01-03 Thread Tom Lane
xbzhang xbzh...@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

Re: [GENERAL] Why the size (PQ_BUFFER_SIZE) of backend send buffers is 8192 ?

2014-01-03 Thread Andrew Sullivan
On Fri, Jan 03, 2014 at 10:00:42AM -0500, Tom Lane wrote: know the end-to-end MTU size with any reliability. Well, you could try PMTU discovery, though I agree that it's not great. It also seems pretty low-level for something like the DBMS to be doing. A -- Andrew Sullivan