Debugging slow write performance in PostgreSQL (GiN indexes)

A journey debugging slow write performance on PostgreSQL. Assumptions, validation, community support and lessons learned.