Re: refactoring relation extension and BufferAlloc(), faster COPY

From: Andres Freund <andres(at)anarazel(dot)de>
To: vignesh C <vignesh21(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org, Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Melanie Plageman <melanieplageman(at)gmail(dot)com>, Yura Sokolov <y(dot)sokolov(at)postgrespro(dot)ru>, Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: refactoring relation extension and BufferAlloc(), faster COPY
Date: 2023-01-10 02:07:49
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers


On 2023-01-06 11:52:04 +0530, vignesh C wrote:
> On Sat, 29 Oct 2022 at 08:24, Andres Freund <andres(at)anarazel(dot)de> wrote:
> >
> > The patches here aren't fully polished (as will be evident). But they should
> > be more than good enough to discuss whether this is a sane direction.
> The patch does not apply on top of HEAD as in [1], please post a rebased
> patch.

Thanks for letting me now. Updated version attached.


Andres Freund

Attachment Content-Type Size
v2-0001-aio-Add-some-error-checking-around-pinning.patch text/x-diff 3.1 KB
v2-0002-hio-Release-extension-lock-before-initializing-pa.patch text/x-diff 2.0 KB
v2-0003-Add-smgrzeroextend-FileZero-FileFallocate.patch text/x-diff 12.0 KB
v2-0004-bufmgr-Add-Pin-UnpinLocalBuffer.patch text/x-diff 5.3 KB
v2-0005-bufmgr-Acquire-and-clean-victim-buffer-separately.patch text/x-diff 27.1 KB
v2-0006-bufmgr-Support-multiple-in-progress-IOs-by-using-.patch text/x-diff 12.4 KB
v2-0007-bufmgr-Move-relation-extension-handling-into-Bulk.patch text/x-diff 31.5 KB
v2-0008-Convert-a-few-places-to-ExtendRelationBuffered.patch text/x-diff 13.5 KB
v2-0009-heapam-Add-num_pages-to-RelationGetBufferForTuple.patch text/x-diff 6.8 KB
v2-0010-hio-Use-BulkExtendRelationBuffered.patch text/x-diff 7.0 KB
v2-0011-bufmgr-debug-Add-PrintBuffer-Desc.patch text/x-diff 3.0 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message David Rowley 2023-01-10 02:13:43 Re: Allow DISTINCT to use Incremental Sort
Previous Message Andres Freund 2023-01-10 02:05:01 Re: postgres_fdw uninterruptible during connection establishment / ProcSignalBarrier