Horton
Menu

Re: AIO writes vs hint bits vs checksums

Heikki Linnakangas <hlinnaka@iki.fi>

View thread
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Andres Freund <andres@anarazel.de>
Cc: pgsql-hackers@postgresql.org, Noah Misch <noah@leadboat.com>, Robert Haas <robertmhaas@gmail.com>, Thomas Munro <thomas.munro@gmail.com>
Date: 2025-04-01T15:11:27Z
Lists: pgsql-hackers 
On 01/04/2025 18:08, Andres Freund wrote:
> Hi,
> 
> On 2025-04-01 13:34:53 +0300, Heikki Linnakangas wrote:
>> Here's a rebase of these patches.
> 
> Thanks!
> 
> Curious what made you do this? Do you need any parts of this soon?

No, I was just browsing through the commitfest.

>> I went ahead and committed the "heapam: Only set tuple's block once per page
>> in pagemode" patch, because it was trivial and independent of the rest.
> 
> Thanks!
> 
> I think I should just commit the kill_prior_tuples test, it's better than
> nothing.

+1. I didn't look at it closely, but more tests is better and it's 
independent of the rest of the patches.

-- 
Heikki Linnakangas
Neon (https://neon.tech)

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

  1. Require share-exclusive lock to set hint bits and to flush

  2. heapam: Move logic to handle HEAP_MOVED into a helper function

  3. Add very basic test for kill_prior_tuples

  4. aio: Add README.md explaining higher level design

  5. heapam: Only set tuple's block once per page in pagemode

  6. bufmgr: Use AIO in StartReadBuffers()

  7. bufmgr: Implement AIO read support

  8. aio: Implement support for reads in smgr/md/fd

  9. aio: Add io_method=io_uring

  10. aio: Add io_method=worker

  11. aio: Infrastructure for io_method=worker

  12. aio: Add core asynchronous I/O infrastructure

  13. bufmgr: Make it easier to change number of buffer state bits