I've been doing PostgreSQL full time since 2013. I do consulting, training, and auditing out of Paris, France. I am also the co-founder and co-organizer of pgDay Paris.
The main difference between an RDBMS (Relational Database Management System) and just loading and saving data to a plain file is concurrency. How do we allow multiple users to manipulate our data at the same time without stepping on each other's toes?
There are several techniques available, and this talk will present most of them. There are things that the RDBMS will take care of all by itself, and there are things that the user can specifically direct the RDBMS to do.
We will look at the basics of Multi-version Concurrency Control (MVCC) and how it is implemented in PostgreSQL. Then we will look at some options the user can invoke such as LOCK TABLE and FOR KEY SHARE. If you don't understand those two clauses, or if you don't know how they work, then this talk is for you.