Re: [RFC][PATCH]: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up - Mailing list 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