Parallelism in #PostgreSQL - Ibrar Ahmed - #Percona Live Online 2020

Comment 💬, Share 🔗, Like 👍🏻, and Subscribe ✅ to our channel + Turn on the 🔔

#PostgreSQL's architecture is process-based instead of thread-based. #PostgreSQL launches a process "postmaster" on startup and after that spans a new process whenever a new client connects to #PostgreSQL. Before version 10 there was no #parallelism in a single connection. It is true that multiple queries from a different client can have parallelism because of process architecture, but a single query runs serially and did not have parallelism. This is a huge limitation because a single query cannot utilize the multi-core. #PostgreSQL introduced parallelism in version 9.6. Parallelism in a sense where a single process can have multiple threads to query the system and utilize the multicore in a system. I will discuss all the parallel scans options which are in #PostgreSQL with the benchmark of these scans.

📺Subscribe To Our Channel and Get More information about #OpenSource #Databases, #kubernetes and many other things.

You can find more about #PostgreSQL Parallelism and Percona Live Online 2020 in these links 👇🏻👇🏻👇🏻

Connect With us on our Social Networks 👇🏻👇🏻👇🏻

[CAUTHAYAKUMAR]

Hai, I got good understanding through this video.I created one function declare a volatile, parallel unsafe(the function contain only select query).In sometime the function resulted nothing after some attempts show a data..This was the cause because of using parallel unsafe??