Index-Only Scans, Lock Table, Hot Standby Feedback, Large Backups | Scaling Postgres 54
In this episode of Scaling Postgres, we review articles covering index-only scans, locking tables, hot standby feedback and handling very large backups.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://scalegrid.io/blog/2019-database-trends-sql-vs-nosql-top-databases-single-vs-multiple-database-use/
https://medium.com/pgmustard/index-only-scans-in-postgres-a1603f551ee
https://www.cybertec-postgresql.com/en/lock-table-can-harm-your-database/
http://richyen.com/replication/postgres/hot_standby_feedback/2019/03/05/i_fought_the_wal.html
https://rob.conery.io/2019/03/04/postgresql-tools-for-the-visually-inclined/
https://medium.com/leboncoin-engineering-blog/managing-postgresql-backups-and-replication-for-very-large-databases-part-2-1ec10d95e443
http://highscalability.com/blog/2018/12/5/how-shiftleft-uses-postgresql-extension-timescaledb.html
https://www.percona.com/blog/2019/03/06/settling-the-myth-of-transparent-hugepages-for-databases/
https://www.percona.com/blog/2018/12/20/benchmark-postgresql-with-linux-hugepages/
Create your
podcast in
minutes
It is Free