
Episode 225 PSQL GEXEC, Delete Duplicates, Postgres Podcast, Puny to Powerful
Bikking
Description
<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.cybertec-postgresql.com/en/gexec-psql-postgresql-poweruser-practice/"> https://www.cybertec-postgresql.com/en/gexec-psql-postgresql-poweruser-practice/</a></li> <li><a href= "https://www.postgresql.org/docs/14/functions-string.html#FUNCTIONS-STRING-FORMAT"> https://www.postgresql.org/docs/14/functions-string.html#FUNCTIONS-STRING-FORMAT</a></li> <li><a href= "https://sqlfordevs.io/delete-duplicate-rows">https://sqlfordevs.io/delete-duplicate-rows</a></li> <li><a href= "https://www.pgmustard.com/blog/postgres-fm-a-new-postgres-podcast"> https://www.pgmustard.com/blog/postgres-fm-a-new-postgres-podcast</a></li> <li><a href= "https://www.youtube.com/watch?v=CIYbpYKrX8Y">https://www.youtube.com/watch?v=CIYbpYKrX8Y</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-waiting-for-postgres-16-subquery-alias-optional"> https://pganalyze.com/blog/5mins-postgres-waiting-for-postgres-16-subquery-alias-optional</a></li> <li><a href= "https://www.youtube.com/watch?v=mJw3al4Ms2o">https://www.youtube.com/watch?v=mJw3al4Ms2o</a></li> <li><a href= "https://ardentperf.com/2022/07/16/postgresql-performance-puzzle/">https://ardentperf.com/2022/07/16/postgresql-performance-puzzle/</a></li> <li><a href= "https://postgresql.life/post/laura_ricci/">https://postgresql.life/post/laura_ricci/</a></li> <li><a href= "https://www.rubberduckdevshow.com/episodes/51-andrew-mason-collin-jilbert-ruby-radar/"> https://www.rubberduckdevshow.com/episodes/51-andrew-mason-collin-jilbert-ruby-radar/</a></li> </ul> <p> </p>