Scaling Postgres

In this episode of Scaling Postgres, we review articles covering database constraints, user defined ordering, how PostgreSQL is terrible, TimeScaleDB and using logical replication for upgrades. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.citusdata.com/blog/2018/03/19/postgres-database-constraints/ https://begriffs.com/posts/2018-03-20-user-defined-order.html https://www.cybertec-postgresql.com/en/postgresql-speeding-up-analytics-and-windowing-functions/ http://thebuild.com/presentations/pgnordic-2018-terrible.pdf https://www.youtube.com/watch?v=IaZ4hJ3G7wc https://severalnines.com/blog/overview-logical-replication-postgresql https://blog.2ndquadrant.com/near-zero-downtime-automated-upgrades-postgresql-clusters-cloud/ http://slides.com/apatheticmagpie/automated-upgrades-of-postgres-2 https://azure.microsoft.com/en-us/blog/announcing-general-availability-of-azure-database-services-for-mysql-and-postgresql/ https://joelonsql.com/2018/0