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/