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

From Tom Lane
Subject Re: A little COPY speedup
Date
Msg-id 12674.1172775931@sss.pgh.pa.us
Whole thread Raw
In response to A little COPY speedup  (Heikki Linnakangas <heikki@enterprisedb.com>)
Responses Re: A little COPY speedup
List pgsql-patches
Heikki Linnakangas <heikki@enterprisedb.com> writes:
> On every row, PageAddItem will scan all the line pointers on the target
> page, just to see that they're all in use, and create a new line
> pointer. That adds up, especially with narrow tuples like what I used in
> the test.
> Attached is a fix for that.

This has been proposed before, and rejected before.  IIRC the previous
patch was quite a lot less invasive than this one (it didn't require
making special space on heap pages).  I don't recall why it wasn't
accepted.

            regards, tom lane

pgsql-patches by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: A little COPY speedup
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Deadlock with pg_dump?