Episode 225 PSQL GEXEC, Delete Duplicates, Postgres Podcast, Puny to Powerful
Episode 225 PSQL GEXEC, Delete Duplicates, Postgres Podcast, Puny to Powerful

Episode 225 PSQL GEXEC, Delete Duplicates, Postgres Podcast, Puny to Powerful

Bikking

10 min0 plays0 favorites
Business & Finance
Play

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>

Creators

pip_flow

pip_flow

Creator