| From: | Andreas Schmitz <schmitz(at)occamlabs(dot)de> |
|---|---|
| To: | Oliver Jowett <oliver(at)opencloud(dot)com> |
| Cc: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: bytea performance tweak |
| Date: | 2011-06-23 10:06:16 |
| Message-ID: | 20110623100616.GA14152@summalogicae.occamlabs.local |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc |
Oliver Jowett wrote:
Hi,
> On 23 June 2011 02:17, Andreas Schmitz <schmitz(at)occamlabs(dot)de> wrote:
>
> > I was wondering why the protocol uses such an encoding anyway. Wouldn't
> > it be a lot faster just sending the bytes as they are?
>
> We can request binary-format data, which for bytea is indeed just the
> raw bytes, but the problem is that it's all or nothing: if we request
> binary data we have to handle binary results for all datatypes, not
> just bytea (because the request is per-column and generally the driver
> doesn't know the column type at the point it makes the request)
> Some progress has been made with that, but it's not production-ready
> yet I think.
ok, understood. Is there a timeline for fully supporting the binary
protocol?
Best regards, Andreas
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marc-André Laverdière | 2011-06-27 06:18:12 | Re: Support for cert auth in JDBC |
| Previous Message | Oliver Jowett | 2011-06-22 23:23:41 | Re: bytea performance tweak |