Presented by:

78c648e7837ede9baac752a99f4b27ad

Piotr Jarmuż

Allegro S.A.
No video of the event yet, sorry!

My presentation is about writing extensions in Postgres. I have written pg_threads that implements simplified POSIX thread API inside Postgres database. It adds a new powerful abstraction giving database developers new opportunities for writing parallel code thus taking advantage of multicore CPUs. There is an extra API for transactional and non-transactional IPC between threads. I also have an example application that takes advantage of this new API that scales linearly even across 2 nodes. The presentation is with live working demo using vagrant project with 2 VMs running  Ubuntu with 2 Postgres 11 databases.

Date:
2019 October 8 11:20
Duration:
40 min
Room:
Boundary
Conference:
South Africa 2019
Language:
Track:
Development
Difficulty:
Hard