Improved Common Table Expressions in recent release of Postgres
How to get rid of deadlocks
What is transaction isolation level? What are differences? What are the default values for RDBMSs?