Scaling Postgres Episode 179 Foreign Data Wrapper | Timescale Compression | Fuzzy Search | Query Execution

In this episode of Scaling Postgres, we discuss how to use foreign data wrappers, compression available in timescaledb, working with fuzzy search and describing Postgres query execution.

Content Discussed

• Understanding Foreign Data Wrappers in Postgres and postgres_fdw
• Timescale, Compression and OpenStreetMap Tags
• A Handbook to Implement Fuzzy Search in PostgreSQL
• Postgres query execution: simple query
• How batch insertion was done in postgres_fdw
• pgbench --client --jobs
• Waiting for PostGIS 3.2: Secure Cloud Raster Access
• Validate PostgreSQL extension upgrade scripts using pg_validate_extupgrade
• pg_timetable v4 is out and available immediately!
• Andrey Borodin
• Rubber Duck Dev Show Episode 9 | Writing Performant Code

YouTube Video