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.

Subscribe at https://www.scalingpostgres.com to get notified of new episodes.

Links for this episode:

• https://about.gitlab.com/blog/2022/06/02/splitting-database-into-main-and-ci/
• https://gitlab.com/groups/gitlab-org/-/epics/6168
• https://docs.gitlab.com/ee/development/database/multiple_databases.html
• https://www.rubberduckdevshow.com/episodes/49-fast-text-search-in-postgres/
• https://www.depesz.com/2022/07/05/understanding-pg_stat_activity/
• https://www.cybertec-postgresql.com/en/handling-bonus-programs-in-sql/
• https://www.crunchydata.com/blog/choosing-a-postgresql-number-format
• https://www.crunchydata.com/blog/data-to-go-postgres-logical-replication
• https://www.percona.com/blog/postgresql-replication-and-conflicts/
• https://www.timescale.com/blog/state-of-postgresql-2022-first-findings/
• https://pganalyze.com/blog/5mins-postgres-lock-monitoring-lwlock-log-lock-waits
• https://www.depesz.com/2022/07/04/how-to-log-selects-from-specific-table/
• https://postgrespro.com/blog/pgsql/5969618
• https://rubyonrails.org/2022/7/4/this-week-in-rails-improved-postgresql-support-performance-improvements-and-more-e462895a
• https://www.timescale.com/blog/what-is-sql-used-for-build-environments-where-devs-can-experiment/
• https://postgresql.life/post/julien_tachoires/