Re: A little COPY speedup - Mailing list pgsql-patches

From Tom Lane
Subject Re: A little COPY speedup
Date
Msg-id 6099.1172847597@sss.pgh.pa.us
Whole thread Raw
In response to Re: A little COPY speedup  ("Simon Riggs" <simon@2ndquadrant.com>)
Responses Re: A little COPY speedup  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-patches
"Simon Riggs" <simon@2ndquadrant.com> writes:
> I'm slightly worried though since that seems to have changed from 8.2,
> which I oprofiled over Christmas.

If you were testing a case with wider rows than Heikki tested, you'd see
less impact --- the cost of the old way was O(N^2) in the number of
tuples that fit on a page, so the behavior gets rapidly worse as you get
down to smaller tuple sizes.  (Come to think of it, the cmin/cmax
collapse would be a factor here too.)

            regards, tom lane

pgsql-patches by date:

Previous
From: Gregory Stark
Date:
Subject: Re: Numeric patch to add special-case representations for < 8 bytes
Next
From: Tom Lane
Date:
Subject: Re: Move cursor support for pl/pgsql