Re: COPY speedup

I'm doing some more exploration with oprofile...

I've got the glibc-debug package installed (on kubuntu), but oprofile
doesn't seem to know about it. I wonder what part of glibc gets 60% of the
run time... do I have to set a magic option in the postgres config ?

samples % image name app name symbol
name
155312 61.7420 libc-2.7.so libc-2.7.so
/lib/tls/i686/cmov/libc-2.7.so
35921 14.2799 postgres postgres
CopyOneRowTo
7485 2.9756 postgres postgres
CopySendData
5626 2.2365 postgres postgres
MemoryContextAlloc
5174 2.0568 postgres postgres
FunctionCall1
5167 2.0541 no-vmlinux no-vmlinux
/no-vmlinux
5087 2.0223 postgres postgres
AllocSetAlloc
4340 1.7253 postgres postgres int4out
3896 1.5488 postgres postgres
heap_deform_tuple