Scaling Postgres Episode 210 Date Time Bins, Search Every Field, JSON_TABLE, Picking Primary
Get New Episodes Weekly!
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.
Content Discussed
- PostgreSQL: mapping timestamps (date_bin)
- DBA tips ‘n tricks – search in every field in a table
- Waiting for PostgreSQL 15 – JSON_TABLE
- target_session_attrs
- New target_session_attrs settings for high availability and scaling in PostgreSQL v14
- Enhancements to the target_session_attrs database connection parameter in PostgreSQL 14
- 5mins of Postgres E12: The basics of tuning VACUUM and autovacuum
- On Shapefiles and PostGIS
- How to enable SSL for postgres connections
- DLE 3.1: pgBackRest, timezones for CLI, DLE community
- Taras Kloba
- Rubber Duck Dev Show Episode 37 | Working With Outside Teams
YouTube Video
