Scaling Postgres

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