Episode 210 Date Time Bins, Search Every Field, JSON_TABLE, Picking Primary

<p>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.</p> <p>Subscribe at https://www.scalingpostgres.com to get notified of new episodes.</p> <p>Links for this episode:</p> <ul> <li><a href= "https://www.cybertec-postgresql.com/en/postgresql-mapping-timestamps-date_bin/"> https://www.cybertec-postgresql.com/en/postgresql-mapping-timestamps-date_bin/</a></li> <li><a href= "https://www.depesz.com/2022/04/05/dba-tips-n-tricks-search-in-every-field-in-a-table/"> https://www.depesz.com/2022/04/05/dba-tips-n-tricks-search-in-every-field-in-a-table/</a></li> <li><a href= "https://www.depesz.com/2022/04/06/waiting-for-postgresql-15-json_table/"> https://www.depesz.com/2022/04/06/waiting-for-postgresql-15-json_table/</a></li> <li><a href= "https://www.postgresql.org/docs/14/libpq-connect.html#LIBPQ-CONNECT-TARGET-SESSION-ATTRS"> https://www.postgresql.org/docs/14/libpq-connect.html#LIBPQ-CONNECT-TARGET-SESSION-ATTRS</a></li> <li><a href= "https://www.cybertec-postgresql.com/en/new-target_session_attrs-settings-for-high-availability-and-scaling-in-postgresql-v14/"> https://www.cybertec-postgresql.com/en/new-target_session_attrs-settings-for-high-availability-and-scaling-in-postgresql-v14/</a></li> <li><a href= "https://www.postgresql.fastware.com/blog/enhancement-to-target-session-attrs"> https://www.postgresql.fastware.com/blog/enhancement-to-target-session-attrs</a></li> <li><a href= "https://pganalyze.com/blog/5mins-postgres-tuning-vacuum-autovacuum"> https://pganalyze.com/blog/5mins-postgres-tuning-vacuum-autovacuum</a></li> <li><a href= "https://www.endpointdev.com/blog/2022/04/shapefiles-postgis/">https://www.endpointdev.com/blog/2022/04/shapefiles-postgis/</a></li> <li><a href= "https://dev.to/yugabyte/how-to-enable-ssl-for-postgres-connections-5321"> https://dev.to/yugabyte/how-to-enable-ssl-for-postgres-connections-5321</a></li> <li><a href= "https://postgres.ai/blog/20220405-database-lab-engin