Re: [RFC][PATCH]: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up
Andres Freund <andres@anarazel.de>
From: Andres Freund <andres@anarazel.de>
To: pgsql-hackers@postgresql.org
Cc: Stephen Frost <sfrost@snowman.net>
Date: 2010-05-20T20:49:04Z
Lists: pgsql-hackers
Hi Stephen, On Thursday 20 May 2010 22:39:26 Stephen Frost wrote: > * Andres Freund (andres@anarazel.de) wrote: > > Statement: > > INSERT INTO blub SELECT a.i, b.i, a.i *b.i FROM generate_series(1, 10000) > > a(i), generate_series(1, 1000) b(i); > > > > legacy crc: > Is this legacy crc using the function-based calls, or the macro? Do you > have statistics for the zlib approach vs unmodified PG? 'legacy' is out of line as well. I couldn't find a real performance difference above noise between out of line (function) and inline (macro). If anything out of line was a bit faster (instruction cache usage could cause that). So vanilla<->zlib should be the same as legacy<->zlib Greetings, Andres