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
PostgreSQL reconsiders its process-based model
Posted Jun 29, 2023 20:48 UTC (Thu)
by kevincox (guest, #93938)
[Link] (2 responses)
Posted Jun 29, 2023 20:48 UTC (Thu) by kevincox (guest, #93938) [Link] (2 responses)
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)
Posted Jun 30, 2023 1:30 UTC (Fri) by andresfreund (subscriber, #69562) [Link] (1 responses)
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]
Posted Jun 30, 2023 4:24 UTC (Fri) by andresfreund (subscriber, #69562) [Link]