Скачать или смотреть 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