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
Can I ask for some independent performance results please?
pgsql-patches by date
|Next:||From: manolo.espa||Date: 2008-02-26 15:10:38|
|Subject: Re: [HACKERS] 2WRS [WIP]|
|Previous:||From: Peter Eisentraut||Date: 2008-02-26 14:43:09|
|Subject: Re: DTrace not working after SUBSYS.o reorg|