Re: Patch for binary receive of basic array types

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Mikko Tiihonen" <mikko(dot)tiihonen(at)nitorcreations(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: Patch for binary receive of basic array types
Date: 2011-09-23 21:49:23
Message-ID: 4E7CB8930200002500041683@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Mikko Tiihonen <mikko(dot)tiihonen(at)nitorcreations(dot)com> wrote:

> summary: speed-up 3-57%, row-length on the wire increases
> typically between 50% and 200% (smaller increases for larger
> arrays or complex types)
>
> I think the speed-up is enough to justify using of binary
> transfers for arrays by default even though the data amount on the
> wire is increased.

What would it take to get the other behavior if you have a network
bottleneck but CPU time to spare?

-Kevin

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message alexbruy 2011-09-24 07:59:06 Re: Prepared statement with function as argument: how to bind values?
Previous Message Mikko Tiihonen 2011-09-23 21:31:24 Patch for binary receive of basic array types