| From: | Melanie Plageman <melanieplageman(at)gmail(dot)com> |
|---|---|
| To: | PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
| Cc: | Andres Freund <andres(at)anarazel(dot)de> |
| Subject: | Re: Checkpointer write combining |
| Date: | 2025-09-08 23:44:02 |
| Message-ID: | CAAKRu_bQWv5hJH0ncbGw8BEufAxdwMw4KY0KYuYLaw6KA=fpCA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Tue, Sep 2, 2025 at 5:10 PM Melanie Plageman
<melanieplageman(at)gmail(dot)com> wrote:
>
> The attached patchset implements checkpointer write combining -- which
> makes immediate checkpoints at least 20% faster in my tests.
> Checkpointer achieves higher write throughput and higher write IOPs
> with the patch.
These needed a rebase. Attached v2.
- Melanie
| Attachment | Content-Type | Size |
|---|---|---|
| v2-0002-Split-FlushBuffer-into-two-parts.patch | text/x-patch | 5.7 KB |
| v2-0003-Eagerly-flush-bulkwrite-strategy-ring.patch | text/x-patch | 10.6 KB |
| v2-0004-Write-combining-for-BAS_BULKWRITE.patch | text/x-patch | 15.8 KB |
| v2-0001-Refactor-goto-into-for-loop-in-GetVictimBuffer.patch | text/x-patch | 12.2 KB |
| v2-0005-Fix-XLogNeedsFlush-for-checkpointer.patch | text/x-patch | 1.9 KB |
| v2-0006-Add-database-Oid-to-CkptSortItem.patch | text/x-patch | 1.7 KB |
| v2-0007-Implement-checkpointer-data-write-combining.patch | text/x-patch | 10.9 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2025-09-08 23:46:11 | Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible |
| Previous Message | Masahiko Sawada | 2025-09-08 23:25:47 | CopyMultiInsertInfo.bufferedBytes is not increased in binary format cases |