Re: [HACKERS] Varchar and binary protocol

2011-02-10 Thread Merlin Moncure
On Thu, Feb 10, 2011 at 2:56 AM, Radosław Smogura wrote: > Merlin Moncure Thursday 10 February 2011 08:48:26 >> On Sat, Feb 5, 2011 at 4:59 PM, Radosław Smogura >> >> Since there is basically zero difference in how *varchar* is handled >> in the database for the text or binary protocols (AFAIK, t

Re: [HACKERS] Varchar and binary protocol

2011-02-09 Thread Radosław Smogura
Actually difference is http://archives.postgresql.org/pgsql-hackers/2011-02/msg00415.php Merlin Moncure Thursday 10 February 2011 08:48:26 > On Sat, Feb 5, 2011 at 4:59 PM, Radosław Smogura > > wrote: > > Hi, > > > > I do performance tests against orignal JDBC driver and my version in > > bina

Re: [HACKERS] Varchar and binary protocol

2011-02-09 Thread Merlin Moncure
On Sat, Feb 5, 2011 at 4:59 PM, Radosław Smogura wrote: > Hi, > > I do performance tests against orignal JDBC driver and my version in binary > and in text mode. I saw strange results when I was reading varchar values. > Here is some output from simple benchmark > > Plain strings speed   Execution

Re: [HACKERS] Varchar and binary protocol

2011-02-09 Thread Noah Misch
On Sat, Feb 05, 2011 at 10:59:45PM +0100, Rados??aw Smogura wrote: > I do performance tests against orignal JDBC driver and my version in binary > and in text mode. I saw strange results when I was reading varchar values. > Here is some output from simple benchmark > > Plain strings speed Execu

[HACKERS] Varchar and binary protocol

2011-02-05 Thread Radosław Smogura
Hi, I do performance tests against orignal JDBC driver and my version in binary and in text mode. I saw strange results when I was reading varchar values. Here is some output from simple benchmark Plain strings speed Execution: 8316582, local: 2116608, all: 10433190 Binary str