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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://www.youtube.com/watch?v=7-dBSYdU468
- https://www.youtube.com/channel/UCBJFH4NZGzh9ieixIxu8cfg/videos
- https://www.datadoghq.com/blog/postgresql-vacuum-monitoring/
- http://info.crunchydata.com/blog/fast-csv-and-json-ingestion-in-postgresql-with-copy
- https://www.postgresql.org/docs/current/static/populate.html
- https://www.cybertec-postgresql.com/en/advanced-sql-why-first_value-and-last_value-are-no-bugs/
- http://www.databasesoup.com/2018/04/new-annotated-config-files-for.html
- https://github.com/jberkus/annotated.conf
- https://hunleyd.github.io/posts/Upgrading-PostgreSQL-from-9.4-to-10.3-with-pglogical/
- https://www.rapidloop.com/blog/announcing-pgdash.html
- https://www.citusdata.com/blog/2018/04/05/citus-7-3-broader-sql-coverage-bi-reporting-top-n/
- http://www.pgdba.org/post/2018/01/fun_pgbackrest/
- https://www.scalingpostgres.com/tutorials/postgresql-replication-easy-failback/