In this episode of Scaling Postgres, we discuss PG14's new SQL function In this episode of Scaling Postgres, we discuss research into a performance puzzle, results from a Postgres and pgAdmin survey as well as the impacts of long running queries on Aurora and Postgres.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
- https://ardentperf.com/2022/07/31/researching-the-performance-puzzle/
- https://www.timescale.com/state-of-postgres/2022
- https://www.enterprisedb.com/blog/pgadmin-user-survey-2022
- https://aws.amazon.com/blogs/database/manage-long-running-read-queries-on-amazon-aurora-postgresql-compatible-edition/
- https://pganalyze.com/blog/5mins-postgres-lock-conflicts-amazon-aurora-max-standby-streaming-delay-hot-standby-feedback
- https://www.highgo.ca/2022/08/05/how-to-set-up-nfs-and-run-pg-on-it/
- https://postgresql.life/post/beena_emerson/
- https://www.rubberduckdevshow.com/episodes/53-discussing-no-more-estimates-jason-charnes/