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

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.

Content Discussed

Re-Introducing Hash Indexes in PostgreSQL
PostgreSQL: int4 vs. float4 vs. numeric
Waiting for PostgreSQL 14 – Report progress of COPY commands
Waiting for PostgreSQL 14 – Add idle_session_timeout.
R Predictive Analytics in Data Science Work using PostgreSQL
The mapping of oid and relfilenode in PG
How PostgreSQL Executes Sequential Scans with the Help of Table Access Methods APIs
Sysbench: in-memory Postgres, Postgres is boring
How to run some tasks without user intervention, at specific times?
Gunnar 'Nick' Bluth