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.
Subscribe at https://www.scalingpostgres.com to get notified of new episodes.
Links for this episode:
https://hakibenita.com/postgresql-hash-index
https://www.cybertec-postgresql.com/en/postgresql-int4-vs-float4-vs-numeric/
https://www.depesz.com/2021/01/12/waiting-for-postgresql-14-report-progress-of-copy-commands/
https://www.depesz.com/2021/01/12/waiting-for-postgresql-14-add-idle_session_timeout/
https://info.crunchydata.com/blog/r-predictive-analytics-in-data-science-work-using-postgresql
https://www.highgo.ca/2021/01/12/the-mapping-of-oid-and-relfilenode-in-pg/
https://www.highgo.ca/2021/01/15/how-postgresql-executes-sequential-scans-with-the-help-of-table-access-methods-apis/
http://smalldatum.blogspot.com/2021/01/sysbench-in-memory-postgres-postgres-is.html
https://www.depesz.com/2021/01/15/how-to-run-some-tasks-without-user-intervention-at-specific-times/
https://postgresql.life/post/gunnar_bluth/