Search


	Podcast:		Scaling Postgres
	Episode:		Episode 210 Date Time Bins, Search Every Field, JSON_TABLE, Picking Primary
	Category:		Technology
	Duration:		00:09:53
	Publish Date:		2022-04-10 23:56:49
	Description:		In this episode of Scaling Postgres, we discuss how to bin date times, search every field of a table, use JSON_TABLE and methods for a client to pick the primary database. Subscribe at https://www.scalingpostgres.com to get notified of new episodes. Links for this episode: https://www.cybertec-postgresql.com/en/postgresql-mapping-timestamps-date_bin/ https://www.depesz.com/2022/04/05/dba-tips-n-tricks-search-in-every-field-in-a-table/ https://www.depesz.com/2022/04/06/waiting-for-postgresql-15-json_table/ https://www.postgresql.org/docs/14/libpq-connect.html#LIBPQ-CONNECT-TARGET-SESSION-ATTRS https://www.cybertec-postgresql.com/en/new-target_session_attrs-settings-for-high-availability-and-scaling-in-postgresql-v14/ https://www.postgresql.fastware.com/blog/enhancement-to-target-session-attrs https://pganalyze.com/blog/5mins-postgres-tuning-vacuum-autovacuum https://www.endpointdev.com/blog/2022/04/shapefiles-postgis/ https://dev.to/yugabyte/how-to-enable-ssl-for-postgres-connections-5321 https://postgres.ai/blog/20220405-database-lab-engine-3-1-released https://postgresql.life/post/taras_kloba/ https://www.rubberduckdevshow.com/episodes/37-working-with-outside-teams/
	Total Play:		0