Scaling Postgres Episode 7 | Any Scale | Monitoring Vacuum | Copy | Annotated Config

In this episode of Scaling Postgres, we review articles covering Postgres at any scale, monitoring vacuum, using copy, annotated config files, and how to do easy replication failback to an old primary database.

Content Discussed

• Postgres at any scale
• PostgreSQL India YouTube Channel
• Monitoring PostgreSQL VACUUM processes
• Fast CSV and JSON Ingestion in PostgreSQL with COPY
• Populating a Database Performance Tips
• Advanced SQL: Why first_value and last_value are no bugs
• New Annotated Config Files for PostgreSQL 10
• Github Annotated.conf Repository
• Upgrading PostgreSQL from 9.4 to 10.3 with pglogical
• Announcing pgDash
• Citus 7.3: Broader SQL coverage, Tableau Integration, TopN extension, and more
• Fun with pgbackrest
• PostgreSQL Replication with Easy Failback

YouTube Video