Re: [RFC][PATCH]: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up
Stephen Frost <sfrost@snowman.net>
From: Stephen Frost <sfrost@snowman.net>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@postgresql.org
Date: 2010-05-20T20:39:26Z
Lists: pgsql-hackers
Andres, * 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: > > zlib: Is this legacy crc using the function-based calls, or the macro? Do you have statistics for the zlib approach vs unmodified PG? > Do you think something like that is sensible? If yes, I will make it into a > proper patch and such. I think that in general we're typically looking for ways to improve performance, yes.. :) Thanks, Stephen