News: 0001537781

  ARM Give a man a fire and he's warm for a day, but set fire to him and he's warm for the rest of his life (Terry Pratchett, Jingo)

PostgreSQL Lands Batch Mode & Other Async I/O Improvements

([Free Software] 5 Hours Ago Postgres AIO)


Last week [1]PostgreSQL merged support for IO_uring that can provide for "considerably faster" performance of this popular open-source database server. Over the weekend some additional improvements were merged to the asynchronous I/O "AIO" code to PostgreSQL, including introducing a new batch mode that can also provide a performance win.

Merged on Sunday were several more I/O improvements for PostgreSQL following the IO_uring support merged days prior. The latest activity includes [2]AIO read support for the buffer manager to perform asynchronous reads into the buffer pool. There were then additional commits to actual begin making use of that AIO read support.

That was followed by a commit to [3]introduce and use optional batch mode support . This batch mode support allows submitting I/O in larger batches to provide for better efficiency than just one-by-one submission. This can help with PostgreSQL performance for many small reads. Due to the semantics around it, the batch mode support is an opt-in feature.

Rounding out the I/O improvements for Postgres this weekend was [4]enabling I/O concurrency on all systems due to overcoming prior limitations.

These I/O improvements for the PostgreSQL database server are building up for the PostgreSQL 18 release due out in September.



[1] https://www.phoronix.com/news/PostgreSQL-Lands-IO_uring

[2] https://github.com/postgres/postgres/commit/047cba7fa0f8c6930b0dd1d93d98c736ef1e4a5a

[3] https://github.com/postgres/postgres/commit/ae3df4b34155d4a3811762e78d5076e64df66fba

[4] https://github.com/postgres/postgres/commit/2a5e709e721cf5f890cde51755b84cfe25d1c4d9



cl333r

numacross

uid313

numacross

Volta

numacross

Linux: Where Don't We Want To Go Today?
-- Submitted by Pancrazio De Mauro, paraphrasing some well-known sales talk