Schedule - PostgreSQL Development Conference 2024

Multi-threaded PostgreSQL?

Date: 2024-05-30
Time: 09:00–09:50
Room: Canfor(1600)
Level: Intermediate

I started a thread on pgsql-hackers "Let's make PostgreSQL multi-threaded" in June. That spurred a lot of discussion, which even made it to LWN and hacker news.

There is little code to show, but I will paint a picture of what it would look like:

  • Multithreading vs multi-process architectures in general
  • Pros and cons
  • How exactly multiple threads could be used
  • Hybrid approaches
  • Previous attempts
  • How other large projects have made the switch
  • How PostgreSQL can make the switch

Talk recorded at https://youtu.be/1_8Kc9nBh20.

Speaker

Heikki Linnakangas