Content-Length: 11828 | pFad | http://lwn.net/Articles/935719/

PostgreSQL reconsiders its process-based model [LWN.net]
|
|
Subscribe / Log in / New account

PostgreSQL reconsiders its process-based model

PostgreSQL reconsiders its process-based model

Posted Jun 22, 2023 3:48 UTC (Thu) by eklitzke (subscriber, #36426)
In reply to: PostgreSQL reconsiders its process-based model by rrolls
Parent article: PostgreSQL reconsiders its process-based model

Using an event driven model doesn't really make sense for a database that needs to be portable and is doing blocking file I/O.


to post comments

PostgreSQL reconsiders its process-based model

Posted Jun 29, 2023 20:48 UTC (Thu) by kevincox (guest, #93938) [Link] (2 responses)

Doesn't io_uring support true async IO for filesystem access now? Maybe it would make sense to transition to that. Definitely a bit early and a risky move but it is an interesting path forward.

Of course in a database you are hoping that a lot of your data is in memory, so maybe the gains wouldn't be nearly as much as with a network service.

PostgreSQL reconsiders its process-based model

Posted Jun 30, 2023 1:30 UTC (Fri) by andresfreund (subscriber, #69562) [Link] (1 responses)

> Doesn't io_uring support true async IO for filesystem access now? Maybe it would make sense to transition to that. Definitely a bit early and a risky move but it is an interesting path forward.

We are working on that....

> Of course in a database you are hoping that a lot of your data is in memory, so maybe the gains wouldn't be nearly as much as with a network service.

You do also need to write data as a database and sometimes that needs to happen in the critical path (e.g. journal commits) of returning to the user. So far it doesn't seem to help a lot on high end local NVMe, but seems quite promising for typical cloud storage.

PostgreSQL reconsiders its process-based model

Posted Jun 30, 2023 4:24 UTC (Fri) by andresfreund (subscriber, #69562) [Link]

( "we" being the postgres project)


Copyright © 2025, Eklektix, Inc.
Comments and public postings are copyrighted by their creators.
Linux is a registered trademark of Linus Torvalds









ApplySandwichStrip

pFad - (p)hone/(F)rame/(a)nonymizer/(d)eclutterfier!      Saves Data!


--- a PPN by Garber Painting Akron. With Image Size Reduction included!

Fetched URL: http://lwn.net/Articles/935719/

Alternative Proxies:

Alternative Proxy

pFad Proxy

pFad v3 Proxy

pFad v4 Proxy