| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
| Cc: | Shachar Shemesh <shachar(at)shemesh(dot)biz>, Julian Heeb <heebj2000(at)yahoo(dot)de>, oledb-devel(at)pgfoundry(dot)org, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server |
| Date: | 2007-05-19 21:51:21 |
| Message-ID: | 18730.1179611481@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
> I do recall someone telling me that text mode transfer could actually be
> faster than binary, somewhat to their (and my) surprise.
Seems a bit improbable --- what was their test case?
The only such situation that comes to mind is that some values are
smaller as text than binary (eg "2" is shorter as text than as any
binary numeric format), so in a situation where number of bytes sent
dominates all other costs, text would win. But of course there are also
many values that're smaller in binary format, so I'd think this would
only happen in restricted test cases.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2007-05-19 22:08:09 | Re: Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server |
| Previous Message | Tom Lane | 2007-05-19 21:44:22 | Re: Re: [Oledb-dev] double precision error with pg linux server, but not with windows pg server |