Scaling Postgres

In this episode of Scaling Postgres, we review articles covering real-time analytics at scale, covering indexes in Postgres 11, 1,500 Postgres upgrades and PostgreSQL vs. MySQL. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://blog.algolia.com/building-real-time-analytics-apis/ https://www.cybertec-postgresql.com/en/idle_in_transaction_session_timeout-terminating-idle-transactions-in-postgresql/ https://www.cybertec-postgresql.com/en/get-rid-of-your-unused-indexes/ http://paquier.xyz/postgresql-2/postgres-11-covering-indexes/ http://blog.dataegret.com/2018/03/postgresql-bloatbusters.html https://tapoueh.org/blog/2018/04/postgresql-data-types-date-timestamp-and-time-zones/ https://di.nmfay.com/postgres-vs-mysql https://bricklen.github.io/2018-03-27-Postgres-10-upgrade/ http://info.crunchydata.com/blog/how-to-failover-with-the-postgresql-kubernetes-operator https://www.scalingpostgres.com/tutorials/postgresql-replication-failback-pg-rewind/