Scaling Postgres

In this episode of Scaling Postgres, we review articles covering a fsync stopgap, tuning autovacuum_naptime, upcoming CTE / WITH clause changes and the Postgres community. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://rubytree.lpages.co/scaling-postgres-configuration/ https://www.postgresql.org/about/news/1920/ http://rhaas.blogspot.com/2019/02/tuning-autovacuumnaptime.html https://info.crunchydata.com/blog/with-queries-present-future-common-table-expressions https://medium.com/@hakibenita/be-careful-with-cte-in-postgresql-fca5e24d2119 https://blog.timescale.com/postgresql-database-community/ http://blog.cleverelephant.ca/2019/02/proj4-postgis.html https://blog.2ndquadrant.com/geo-redundancy-postgresql-database-backups-barman/ https://pgstef.github.io/2019/02/20/monitor_pgbackrest_backups_with_nagios.html