On Sun, Oct 31, 2010 at 11:04 PM, Itagaki Takahiro
<itagaki(dot)takahiro(at)gmail(dot)com> wrote:
> On Mon, Nov 1, 2010 at 6:41 AM, Andres Freund <andres(at)anarazel(dot)de> wrote:
>> While looking at binary COPY performance I forgot to add BINARY and was a bit
>> shocked to see printf that high in the profile...
>>
>> A change from 9192.476ms 5309.928ms seems to be pretty good indication that a
>> change in that area is waranted given integer columns are quite ubiquous...
>
> Good optimization. Here is the result on my machine:
> * before: 13057.190 ms, 12429.092 ms, 12622.374 ms
> * after: 8261.688 ms, 8427.024 ms, 8622.370 ms

Wow.  Nice stuff, Andres!

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

In response to

• Re: [PATCH] Custom code int(32|64) => text conversions out of performance reasons at 2010-11-01 03:04:51 from Itagaki Takahiro

pgsql-hackers by date

Next:	From: Itagaki Takahiro	Date: 2010-11-01 03:17:02
	Subject: Comparison with "true" in source code
Previous:	From: Itagaki Takahiro	Date: 2010-11-01 03:04:51
	Subject: Re: [PATCH] Custom code int(32|64) => text conversions out of performance reasons