Re: [HACKERS] Varchar and binary protocol

2011-02-10 Thread Merlin Moncure
On Thu, Feb 10, 2011 at 2:56 AM, Radosław Smogura rsmog...@softperience.eu wrote: Merlin Moncure mmonc...@gmail.com 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

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

Re: [HACKERS] Varchar and binary protocol

2011-02-09 Thread Merlin Moncure
On Sat, Feb 5, 2011 at 4:59 PM, Radosław Smogura rsmog...@softperience.eu 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

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 mmonc...@gmail.com Thursday 10 February 2011 08:48:26 On Sat, Feb 5, 2011 at 4:59 PM, Radosław Smogura rsmog...@softperience.eu wrote: Hi, I do performance tests against orignal JDBC

[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