Hacking with Postgres 11 - pg_threads

Piotr Jarmuż
PostgresConf South Africa 2019
postgresconf.o...
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.