Scaling Postgres Episode 179 Foreign Data Wrapper | Timescale Compress | Fuzzy Search скачать в хорошем качестве

Scaling Postgres Episode 179 Foreign Data Wrapper | Timescale Compress | Fuzzy Search

To get the show notes as well as get notified of new episodes, visit: https://www.scalingpostgres.com/episo... 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. Want to learn more about Postgres performance? Join my FREE mini-course called the PostgreSQL Performance Starter Kit here: https://www.scalingpostgres.com/cours... Timestamps: 00:00 - Intro 00:27 - Understanding Foreign Data Wrappers in Postgres and postgres_fdw 03:03 - Timescale, Compression and OpenStreetMap Tags 06:19 - A Handbook to Implement Fuzzy Search in PostgreSQL 08:58 - Postgres query execution: simple query 10:49 - How batch insertion was done in postgres_fdw 11:24 - pgbench --client --jobs 12:40 - Waiting for PostGIS 3.2: Secure Cloud Raster Access 13:53 - Validate PostgreSQL extension upgrade scripts using pg_validate_extupgrade 14:23 - pg_timetable v4 is out and available immediately! 14:38 - Andrey Borodin 14:49 - Rubber Duck Dev Show Episode 9 | Writing Performant Code 15:15 - Outro #postgres #postgresql