Scaling Postgres

In this episode of Scaling Postgres, we review articles covering Postgres at any scale, monitoring vacuum, using copy, annotated config files, and how to do easy replication failback to an old primary database. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.youtube.com/watch?v=7-dBSYdU468 https://www.youtube.com/channel/UCBJFH4NZGzh9ieixIxu8cfg/videos https://www.datadoghq.com/blog/postgresql-vacuum-monitoring/ http://info.crunchydata.com/blog/fast-csv-and-json-ingestion-in-postgresql-with-copy https://www.postgresql.org/docs/current/static/populate.html https://www.cybertec-postgresql.com/en/advanced-sql-why-first_value-and-last_value-are-no-bugs/ http://www.databasesoup.com/2018/04/new-annotated-config-files-for.html https://github.com/jberkus/annotated.conf https://hunleyd.github.io/posts/Upgrading-PostgreSQL-from-9.4-to-10.3-with-pglogical/ https://www.rapidloop.com/blog/announcing-pgdash.html https://www.citusdata.com/blog/2018/04/0

In this episode of Scaling Postgres, we review articles covering terabyte scale & analytics, database permissions, fast column adding coming to PosgreSQL 11 and pgBouncer. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.youtube.com/watch?v=BgcJnurVFag https://www.youtube.com/watch?v=8mKpfutwD0U https://engineering.squarespace.com/blog/2018/building-on-solid-ground-getting-postgres-foundations-right-with-pgbedrock https://github.com/Squarespace/pgbedrock http://blog.dataegret.com/2018/03/pain-free-add-column-with-non-null.html https://www.datanami.com/2018/03/26/making-hadoop-relatable-again/ http://thebuild.com/blog/2018/03/27/mountpoints-and-the-single-postgresql-server/ http://thebuild.com/blog/2018/03/30/change-this-wal_compression/ https://severalnines.com/blog/guide-using-pgbouncer https://www.scalingpostgres.com/tutorials/postgresql-wal-archiving-pg-receivewal/

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

In this episode of Scaling Postgres, we review articles covering developers loving PostgreSQL, a 50TB database upgrade, information on vacuums, patches for parallel PostGIS plans, database security concerns, DB normalization and primary keys and generate series. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://insights.stackoverflow.com/survey/2018/#technology-most-loved-dreaded-and-wanted-databases https://behind.pretix.eu/2018/03/11/mysql-to-postgres/ https://medium.com/adyen/updating-a-50-terabyte-postgresql-database-f64384b799e7 https://www.cybertec-postgresql.com/en/reasons-why-vacuum-wont-remove-dead-rows/ https://www.postgresql.org/docs/current/static/sql-prepare-transaction.html https://www.cybertec-postgresql.com/en/what-postgresql-full-text-search-has-to-do-with-vacuum/ https://carto.com/blog/inside/postgres-parallel/ https://greenplum.org/postgresql-9-0-oss-greenplum/ https://www.imperva.com/blog/2018/03/deep-dive-database-attacks-

In this episode of Scaling Postgres, we review articles covering modeling, checking for long queries using pg_stat_statements, statistics in PosgreSQL 10 and pgmetrics. Head on over to https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://tapoueh.org/blog/2018/03/database-modelization-anti-patterns/ https://www.cybertec-postgresql.com/en/detecting-performance-problems-easily-in-postgresql/ https://www.citusdata.com/blog/2018/03/06/postgres-planner-and-its-usage-of-statistics/ https://www.opsdash.com/blog/announcing-pgmetrics.html https://severalnines.com/blog/top-pg-clustering-ha-solutions-postgresql https://blog.2ndquadrant.com/postgresql-meltdown-benchmarks/ https://www.scalingpostgres.com/tutorials/postgresql-backup-point-in-time-recovery/

In this episode of Scaling Postgres, we review articles covering analytical DBs (potentially using GPUs), recursive queries and different forms of replication. Head on over to https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://medium.com/plangrid-technology/indexing-with-postgres-when-less-is-more-7337d6f09048 https://www.nextplatform.com/2018/02/26/bringing-gpus-bear-bog-standard-relational-databases/ https://medium.com/@alitech_2017/how-to-create-a-stream-system-with-tens-of-millions-of-feeds-6df06e302c78 https://greenplum.org/ https://tapoueh.org/blog/2018/01/exporting-a-hierarchy-in-json-with-recursive-queries/ https://www.youtube.com/watch?v=ExASIbBIDhM&feature=youtu.be https://www.citusdata.com/blog/2018/02/21/three-approaches-to-postgresql-replication/ https://www.opsdash.com/blog/postgresql-replication-topologies.html https://www.opsdash.com/blog/postgresql-replication-slots.html https://www.youtube.com/watch?v=GZx6TWmztMs

In this episode of Scaling Postgres, we review articles covering petabyte scale techniques as well as various articles on locking. Head on over to https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.scalingpostgres.com/episodes/1-petabyte-scale-and-locking https://heapanalytics.com/blog/engineering/testing-database-changes-right-way https://www.slideshare.net/ChrisTravers5/postgresql-at-20tb-and-beyond https://blog.rustprooflabs.com/2018/02/pg10_parallel_queries https://www.citusdata.com/blog/2018/02/15/when-postgresql-blocks/ https://www.citusdata.com/blog/2018/02/22/seven-tips-for-dealing-with-postgres-locks/ https://blog.fin.com/migrations-and-long-transactions-in-postgres-e6c3fbae56a5 https://pgstef.github.io/2018/02/07/introduction_to_postgresql_automatic_failover.html https://blog.2ndquadrant.com/postgresql-maximum-table-size/