Preview Mode Links will not work in preview mode

Scaling Postgres


Jan 4, 2021

In this episode of Scaling Postgres, we discuss setting up active-active instances with federation, the impact of memory speed, the causes of table rewrites and the Postgres shibboleth.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

https://info.crunchydata.com/blog/active-active-postgres-federation-on-kubernetes

https://info.crunchydata.com/blog/postgresql-13-benchmark-memory-speed-vs.-tps

https://www.thatguyfromdelhi.com/2020/12/what-postgres-sql-causes-table-rewrite.html

https://www.cybertec-postgresql.com/en/the-shibboleth-of-postgresql/

https://www.youtube.com/channel/UCjowqBHD53OEHUtxuLj2JYg/videos

https://www.highgo.ca/2020/12/29/checkpoints-in-postgresql/

https://www.depesz.com/2020/12/24/how-to-install-and-configure-postgresql-debian-ubuntu-for-developer-use-part-1/

https://www.depesz.com/2020/12/29/how-to-install-and-configure-postgresql-debian-ubuntu-for-developer-use-part-2/

https://www.depesz.com/2020/12/21/waiting-for-postgresql-14-pg_stat_statements-track-time-at-which-all-statistics-were-last-reset/

https://www.depesz.com/2020/12/21/waiting-for-postgresql-14-multirange-datatypes/

https://www.depesz.com/2020/12/20/waiting-for-postgresql-14-allow-subscripting-of-hstore-values/

https://info.crunchydata.com/blog/postgresql-pl/python-and-scipy/numpy-for-processing-images

https://people.planetpostgresql.org/devrim/index.php?/archives/106-What-is-new-in-PostgreSQL-13-RPMs.html

https://people.planetpostgresql.org/devrim/index.php?/archives/108-LLVM-issues-with-PostgreSQL-YUM-repository-on-CentOS-8.html

https://people.planetpostgresql.org/devrim/index.php?/archives/109-RPM-repository-for-unsupported-PostgreSQL-releases-distros.html

https://people.planetpostgresql.org/devrim/index.php?/archives/107-Installing-PostGIS-3.1-and-PostgreSQL-13-on-CentOS-8.html

https://info.crunchydata.com/blog/loading-data-into-postgis-an-overview

https://b-peng.blogspot.com/2020/12/load-balancing-in-pgpool.html

https://pgsqlpgpool.blogspot.com/2020/12/timeouts-in-pgpool-ii-connections.html