Re: [RFC][PATCH]: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up - Mailing list pgsql-hackers

From Stephen Frost
Subject Re: [RFC][PATCH]: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up
Date
Msg-id 20100520203926.GN21875@tamriel.snowman.net
Whole thread Raw
In response to [RFC][PATCH]: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up  (Andres Freund <andres@anarazel.de>)
Responses Re: [RFC][PATCH]: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up
List 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

pgsql-hackers by date:

Previous
From: "Kevin Flanagan"
Date:
Subject: ERROR: GIN indexes do not support whole-index scans
Next
From: Andres Freund
Date:
Subject: Re: [RFC][PATCH]: CRC32 is limiting at COPY/CTAS/INSERT ... SELECT + speeding it up