Episode 223 Database Decomposition, Fast Text Search, Understanding pg_stat_activity, Window Functions

<p>In this episode of Scaling Postgres, we discuss the process of decomposing your database, how to search text in Postgres quickly, how to understand the output of pg_stat_activity and how to use window functions to solve a use case.</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://about.gitlab.com/blog/2022/06/02/splitting-database-into-main-and-ci/"> https://about.gitlab.com/blog/2022/06/02/splitting-database-into-main-and-ci/</a></li> <li><a href= "https://gitlab.com/groups/gitlab-org/-/epics/6168">https://gitlab.com/groups/gitlab-org/-/epics/6168</a></li> <li><a href= "https://docs.gitlab.com/ee/development/database/multiple_databases.html"> https://docs.gitlab.com/ee/development/database/multiple_databases.html</a></li> <li><a href= "https://www.rubberduckdevshow.com/episodes/49-fast-text-search-in-postgres/"> https://www.rubberduckdevshow.com/episodes/49-fast-text-search-in-postgres/</a></li> <li><a href= "https://www.depesz.com/2022/07/05/understanding-pg_stat_activity/"> https://www.depesz.com/2022/07/05/understanding-pg_stat_activity/</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/handling-bonus-programs-in-sql/"> https://www.cybertec-postgresql.com/en/handling-bonus-programs-in-sql/</a></li> <li><a href= "https://www.crunchydata.com/blog/choosing-a-postgresql-number-format"> https://www.crunchydata.com/blog/choosing-a-postgresql-number-format</a></li> <li><a href= "https://www.crunchydata.com/blog/data-to-go-postgres-logical-replication"> https://www.crunchydata.com/blog/data-to-go-postgres-logical-replication</a></li> <li><a href= "https://www.percona.com/blog/postgresql-replication-and-conflicts/"> https://www.percona.com/blog/postgresql-replication-and-conflicts/</a></li> <li><a href= "https://www.timescale.com/blog/state-of-postgresql-2022-first-findings/"> https://www.timescale.com/blog/state-of-postgresql-2022-first-findings/</a></li> <li><a href= "https://pganalyze.com/blog/5mins-post