Re: Checkpointer write combining

From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
To: Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: Checkpointer write combining
Date: 2025-09-09 13:39:19
Message-ID: CAAKRu_Yurj0sabXZB5EVqO3fKgwN1vELe1H4e0s1zXV3MKbZjQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 9, 2025 at 9:27 AM Nazir Bilal Yavuz <byavuz81(at)gmail(dot)com> wrote:
>

Thanks for the review!

> From 053dd9d15416d76ce4b95044d848f51ba13a2d20 Mon Sep 17 00:00:00 2001
> From: Melanie Plageman <melanieplageman(at)gmail(dot)com>
> Date: Tue, 2 Sep 2025 11:00:44 -0400
> Subject: [PATCH v2 1/9] Refactor goto into for loop in GetVictimBuffer()
>
> @@ -731,6 +741,13 @@ StrategyRejectBuffer(BufferAccessStrategy
> strategy, BufferDesc *buf, bool from_r
> strategy->buffers[strategy->current] != BufferDescriptorGetBuffer(buf))
> return false;
>
> + buf_state = LockBufHdr(buf);
> + lsn = BufferGetLSN(buf);
> + UnlockBufHdr(buf, buf_state);
> +
> + if (!XLogNeedsFlush(lsn))
> + return true;
>
> I think this should return false.

Oops, you're right. v3 attached with that mistake fixed.

- Melanie

Attachment Content-Type Size
v3-0003-Eagerly-flush-bulkwrite-strategy-ring.patch text/x-patch 10.6 KB
v3-0001-Refactor-goto-into-for-loop-in-GetVictimBuffer.patch text/x-patch 12.2 KB
v3-0002-Split-FlushBuffer-into-two-parts.patch text/x-patch 5.7 KB
v3-0005-Fix-XLogNeedsFlush-for-checkpointer.patch text/x-patch 1.9 KB
v3-0004-Write-combining-for-BAS_BULKWRITE.patch text/x-patch 15.8 KB
v3-0007-Implement-checkpointer-data-write-combining.patch text/x-patch 10.9 KB
v3-0006-Add-database-Oid-to-CkptSortItem.patch text/x-patch 1.7 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Vivek Gadge 2025-09-09 13:50:58 Re: Query Performance Degradation Due to Partition Scan Order – PostgreSQL v17.6
Previous Message Nazir Bilal Yavuz 2025-09-09 13:27:47 Re: Checkpointer write combining