Scaling Postgres Episode 62 | Index Include Clause | Exporting CSV | JSON | Zedstore скачать в хорошем качестве

Scaling Postgres Episode 62 | Index Include Clause | Exporting CSV | JSON | Zedstore

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 review articles covering the index include clause, exporting data to CSV, using JSON in Postgres and Zedstore. 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:24 - A Close Look at the Index Include Clause 05:24 - Exporting CSV from PostgreSQL 06:37 - Having lunch with PostgreSQL, MongoDB and JSON 07:47 - Waiting for PostgreSQL 12 – Allow VACUUM to be run with index cleanup disabled. 08:47 - Waiting for PostgreSQL 12 – Add SETTINGS option to EXPLAIN, to print modified settings. 09:18 - Zedstore - compressed in-core columnar storage 10:41 - 1-to-1 relationship in PostgreSQL for real 11:32 - Masquerade: A Postgres Proxy to Mask Data in Realtime 12:33 - Masquerade Implementation 13:17 - Indexes in PostgreSQL — 7 (GIN) 13:47 - [YouTube] Altering Databases 14:18 - Chicago Open Rideshare Dataset - Getting Starte:d 15:15 - Outro #postgres #postgresql