Following patch implements a simple mechanism to keep a buffer pinned
while we are bulk loading.
Performance gains measured as +20% gain for CREATE TABLE as SELECT, and
15-17% for COPY on very short rows. Measurable difference drops away and
is not measurable at all at 1000/bytes per row.
As a result, patch doesn't bother to implement buffer pinning for TOAST
operations.
Can I ask for some independent performance results please?
--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com