This article discusses the background and security of PostgreSQL HOT Vacuum Link Contraction.
This short article discusses CTID isolation problems and solutions.
This blog article discusses several different method you can use to optimize the write and read operations of large databases using PostgreSQL.