Preview Mode Links will not work in preview mode

Scaling Postgres


May 18, 2020

In this episode of Scaling Postgres, we discuss the Postgres data directory, new vacuum features, binary storage performance and the impact of network latency.

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

Links for this episode:

https://www.postgresql.org/about/news/2038/

https://people.planetpostgresql.org/devrim/index.php?/archives/104-yum-users-some-devel-RPMs-require-a-new-repository.html

https://johnnunemaker.com/postgres-distinct-on/

http://rhaas.blogspot.com/2020/05/dont-manually-modify-postgresql-data.html

http://amitkapila16.blogspot.com/2020/05/improved-autovacuum-in-postgresql-13.html

https://www.cybertec-postgresql.com/en/binary-data-performance-in-postgresql/

https://www.cybertec-postgresql.com/en/postgresql-network-latency-does-make-a-big-difference/

https://richyen.com/postgres/2020/05/15/how-to-spot-an-impostor.html

https://www.highgo.ca/2020/05/15/benefits-of-external-key-management-system-over-the-internal-and-how-they-could-help-securing-postgresql/

https://www.2ndquadrant.com/en/blog/keep-your-libraries-updated-and-nobody-gets-hurt-skip-library-updates-trigger-breakages/

https://mbeena-learnings.blogspot.com/2020/05/multicolumn-partitioning.html

https://www.enterprisedb.com/blog/how-to-use-pgbadger-log-analyzer-postgresql-query-performance

https://www.enterprisedb.com/blog/high-availibility-parameters-configuration-streaming-replication-postgresql

https://dev.to/kaleman15/fuzzy-searching-with-postgresql-97o

https://www.neilwithdata.com/advanced-sql

https://www.highgo.ca/2020/05/15/build-postgresql-and-extension-on-windows/

https://postgresql.life/post/fabrizio_de_royes_mello/