Re: [HACKERS] Optimize postgres protocol for fixed size arrays

2011-11-22 Thread Merlin Moncure
On Tue, Nov 22, 2011 at 3:47 PM, Mikko Tiihonen wrote: > Hi, > > During conversion of the jdbc driver to use binary encoding when receiving > array objects from postgres it was noticed > that for example for int[] arrays the binary encoding is normally 30% to > 200% larger in bytes than the text e

Re: [HACKERS] Optimize postgres protocol for fixed size arrays

2011-11-22 Thread k...@rice.edu
On Tue, Nov 22, 2011 at 11:47:22PM +0200, Mikko Tiihonen wrote: > Hi, > > During conversion of the jdbc driver to use binary encoding when receiving > array objects from postgres it was noticed > that for example for int[] arrays the binary encoding is normally 30% to 200% > larger in bytes than

[HACKERS] Optimize postgres protocol for fixed size arrays

2011-11-22 Thread Mikko Tiihonen
Hi, During conversion of the jdbc driver to use binary encoding when receiving array objects from postgres it was noticed that for example for int[] arrays the binary encoding is normally 30% to 200% larger in bytes than the text encoding. This was of concern to some users with slower links to