Scaling Postgres Episode 148 Hash Indexes | Int Float Numeric | Postgres 14 Features | Data Science

To get the show notes as well as get notified of new episodes, visit:

In this episode of Scaling Postgres, we discuss hash indexes, the int, float and numeric data types, features coming in Postgres 14 and data science in Postgres.

Want to learn more about Postgres performance?

Timestamps:
00:00 - Intro
00:27 - Re-Introducing Hash Indexes in PostgreSQL
05:41 - PostgreSQL: int4 vs. float4 vs. numeric
07:08 - Waiting for PostgreSQL 14 – Report progress of COPY commands
07:38 - Waiting for PostgreSQL 14 – Add idle_session_timeout.
08:16 - R Predictive Analytics in Data Science Work using PostgreSQL
08:53 - The mapping of oid and relfilenode in PG
09:17 - How PostgreSQL Executes Sequential Scans with the Help of Table Access Methods APIs
09:42 - Sysbench: in-memory Postgres, Postgres is boring
10:12 - How to run some tasks without user intervention, at specific times?
11:19 - Gunnar 'Nick' Bluth
11:30 - Outro

#postgres #postgresql