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/