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 pemutaran0 favorit
Business & Finance
Putar

Deskripsi

<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>

Kreator

pip_flow

pip_flow

Creator