Scaling Postgres

In this episode of Scaling Postgres, we discuss /gexec available in psql, how to delete duplicates using a window function, a new Postgres podcast and a performance talk about going from puny to powerful. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/gexec-psql-postgresql-poweruser-practice/ https://www.postgresql.org/docs/14/functions-string.html#FUNCTIONS-STRING-FORMAT https://sqlfordevs.io/delete-duplicate-rows https://www.pgmustard.com/blog/postgres-fm-a-new-postgres-podcast https://www.youtube.com/watch?v=CIYbpYKrX8Y https://pganalyze.com/blog/5mins-postgres-waiting-for-postgres-16-subquery-alias-optional https://www.youtube.com/watch?v=mJw3al4Ms2o https://ardentperf.com/2022/07/16/postgresql-performance-puzzle/ https://postgresql.life/post/laura_ricci/ https://www.rubberduckdevshow.com/episodes/51-andrew-mason-collin-jilbert-ruby-radar/