At PGCon 2009, Jesper Pedersen talked to me about the new Binary Transfer patch which was submitted to the JDBC Driver for Postgres 8.4. I thought it will be nice to compare how the JDBC 8.4 driver compared to older 8.3 JDBC Driver. Hence I took it for a drive

The 8.4 JDBC Driver with BinaryTransfer patch seems to get to a better peak faster but since to taper off at high clients. I don't know if this benchmark was the right benchmark for it. Need more benchmarks which uses JDBC to see the performance difference with this feature.


Comments:

it will be nice, to get a closeup where x>32

Posted by gregj on May 29, 2009 at 05:27 AM EDT #

Could you do a run with -Dorg.postgresql.forcebinary=true ?

Posted by jesperpedersen on May 29, 2009 at 06:58 AM EDT #

I don't think a TPM benchmark will reveal the benefit of binary transfer. Try reading lots of rows that contain dates.

Posted by Ken on September 01, 2009 at 05:48 PM EDT #

I have received several similar emails like this one.

Posted by ed hardy on November 04, 2009 at 09:48 PM EST #

I like this article

Posted by A&F Women on November 05, 2009 at 12:05 AM EST #

Post a Comment:
  • HTML Syntax: NOT allowed

This blog copyright 2009 by Jignesh Shah