Scaling Postgres

In this episode of Scaling Postgres, we review articles covering sysadmin concerns, the power of indexing, pgbouncer monitoring and pg_prewarm. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.postgresql.org/about/news/1890/ http://postgis.net/2018/09/23/postgis-2.5.0/ https://heapanalytics.com/blog/engineering/clocksource-aws-ec2-vdso https://news.ycombinator.com/item?id=18043439 https://blog.2ndquadrant.com/video-power-indexing-in-postgresql/ https://blog.okmeter.io/use-red-and-real-world-pgbouncer-monitoring-61b34ebeebb8 https://postgresrocks.enterprisedb.com/t5/Postgres-Gems/Autoprewarm-a-new-functionality-in-pg-prewarm/ba-p/1908 https://blog.2ndquadrant.com/on-rocks-and-sand/ https://www.citusdata.com/blog/2018/09/27/fun-with-sql-unions-in-postgres/ https://severalnines.com/blog/understanding-check-constraints-postgresql