It may interest you to study this a bit to understand MVCC (Multiversion Concurrency Control).

https://www.postgresql.org/docs/9.6/static/mvcc.html