In this episode of Scaling Postgres, we discuss how to interpret explain analyze, the best ways to load data in bulk, how to limit rows affected by update or delete and using pg_buffercache.

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

Links for this episode:

https://www.cybertec-postgresql.com/en/how-to-interpret-postgresql-explain-analyze-output/

https://www.cybertec-postgresql.com/en/postgresql-bulk-loading-huge-amounts-of-data/

https://blog.crunchydata.com/blog/simulating-update-or-delete-with-limit-in-postgres-ctes-to-the-rescue

https://fluca1978.github.io/2021/05/28/PostgreSQLMemoryFuntions.html

https://www.percona.com/blog/2021/05/27/new-features-in-postgresql-14-bulk-inserts-for-foreign-data-wrappers/

https://www.postgresql.fastware.com/blog/enhancement-to-target-session-attrs

https://www.ongres.com/blog/tracking-materialized-views-refresh-performance-with-mvstat-in-postgresql/

https://seiler.us/2021-05-23-speeding-up-pgbackrest-recovery/

https://pganalyze.com/blog/postgres-row-level-security-ruby-rails

https://paquier.xyz/postgresql-2/postgres-14-hashes/

https://postgresql.life/post/georgios_kokolatos/