Hacking with Postgres 11 - pg_threads
Piotr Jarmuż PostgresConf South Africa 2019 https://postgresconf.org/conferences/... 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.

▶︎
Temporal Journey

▶︎
Basic understanding of EXPLAIN ANALYZE

▶︎
PostgreSQL performance in 5 minutes

▶︎
The Moment That Changed Software Development!

▶︎
The Complete Web Development Roadmap

▶︎
What AI Agent Skills Are and How They Work

▶︎
Backend web development - a complete overview

▶︎
What do tech pioneers think about the AI revolution? - The Engineers, BBC World Service

▶︎
AutoVacuum - Tuning and Monitoring

▶︎
Something is jamming GPS over Europe. Here's what we found

▶︎
40Hz Binaural Gamma Waves - Ultra Deep Concentration

▶︎
Trump Tries to Catch Reflecting Pool “Vandals” & Miami Gets a Scottish Takeover | The Daily Show

▶︎
How to Claim Your Leadership Power | Michael Timms | TED

▶︎
Is JSONB a Silver Bullet

▶︎
Think Faster, Talk Smarter with Matt Abrahams

▶︎
God Says:"TAKE THIS MESSAGE SERIOUSLY, BECAUSE ONLY YOU ARE SEEING IT"/God Message Now/God Message

▶︎
How To Think SO CLEARLY People Assume You're A Genius

▶︎
How to make a good platforming character (Developing 6)

▶︎
Event Stores and Postgres

▶︎
