Search

Home > Scaling Postgres > Episode 223 Database Decomposition, Fast Text Search, Understanding pg_stat_activity, Window Functions


	Podcast:		Scaling Postgres
	Episode:		Episode 223 Database Decomposition, Fast Text Search, Understanding pg_stat_activity, Window Functions
	Category:		Technology
	Duration:		00:15:00
	Publish Date:		2022-07-10 21:55:41
	Description:		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/
	Total Play:		0