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

YouTube Video