Real time analytics | Postgres.FM 033 |
Michael and Nikolay discuss real-time analytics — what it means, what the options are, and some tips if you're trying to implement it within Postgres.
Here are links to a few things we mentioned:
* Loose index scan / skip scan with recursive CTE (wiki) https://wiki.postgresql.org/wiki/Loos...
* Zheap (wiki) https://wiki.postgresql.org/wiki/Zheap
* cstore_fdw (now part of Citus) https://github.com/citusdata/cstore_fdw
* Timescale compression docs https://docs.timescale.com/timescaled...
* Hydra founders interview (on Postgres TV) • Joe Sciarrino and Jonathan Dance. Hyd...
* Materialised views episode https://postgres.fm/episodes/material...
* pg_ivm https://github.com/sraoss/pg_ivm
* Timescale continuous aggregates docs https://docs.timescale.com/timescaled...
* Clickhouse https://clickhouse.com/
* Snowflake https://www.snowflake.com/en/
* Replication episode https://postgres.fm/episodes/replication
* Timescale bottomless storage on S3 https://www.timescale.com/blog/expand...
* pg_partman https://github.com/pgpartman/pg_partman
* Querying Postgres from DuckDB https://duckdb.org/2022/09/30/postgre...
* Heap blog (filter by “Engineering”) https://www.heap.io/blog
* Incremental View Maintenance (wiki) https://wiki.postgresql.org/wiki/Incr...
* PostgreSQL HyperLogLog https://github.com/citusdata/postgres...
* Faster counting (by Joe Nelson on the Citus blog) https://www.citusdata.com/blog/2016/1...
-------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
~~~
This is the uncut version, with video. Check out https://Postgres.fm to find audio-only podcast episodes, edited for convenient listening.