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/03/19/using-pg_badplan-to-create-statistics-is-a-good-plan/
- https://www.scalingpostgres.com/tutorials/postgresql-replication-slots/