37 subscribers
התחל במצב לא מקוון עם האפליקציה Player FM !
Real-time analytics
Manage episode 355645252 series 3369151
Nikolay and Michael 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)
- Zheap (wiki)
- cstore_fdw (now part of Citus)
- Timescale compression docs
- Hydra founders interview (on Postgres TV)
- Materialised views episode
- pg_ivm
- Timescale continuous aggregates docs
- Clickhouse
- Snowflake
- Replication episode
- Timescale bottomless storage on S3 (blog post)
- pg_partman
- Querying Postgres from DuckDB (blog post)
- Heap blog (filter by “Engineering”)
- Incremental View Maintenance (wiki)
- PostgreSQL HyperLogLog
- Faster counting (by Joe Nelson on the Citus blog)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
146 פרקים
Manage episode 355645252 series 3369151
Nikolay and Michael 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)
- Zheap (wiki)
- cstore_fdw (now part of Citus)
- Timescale compression docs
- Hydra founders interview (on Postgres TV)
- Materialised views episode
- pg_ivm
- Timescale continuous aggregates docs
- Clickhouse
- Snowflake
- Replication episode
- Timescale bottomless storage on S3 (blog post)
- pg_partman
- Querying Postgres from DuckDB (blog post)
- Heap blog (filter by “Engineering”)
- Incremental View Maintenance (wiki)
- PostgreSQL HyperLogLog
- Faster counting (by Joe Nelson on the Citus blog)
------------------------
What did you like or not like? What should we discuss next time? Let us know by tweeting us on @samokhvalov / @michristofides / @PostgresFM, or by commenting on our Google doc.
If you would like to share this episode, here's a good link (and thank you!)
Postgres FM is brought to you by:
- Nikolay Samokhvalov, founder of Postgres.ai
- Michael Christofides, founder of pgMustard
With special thanks to:
- Jessie Draws for the amazing artwork
146 פרקים
Kaikki jaksot
×

1 pg_stat_statements track_planning 37:55


ברוכים הבאים אל Player FM!
Player FM סורק את האינטרנט עבור פודקאסטים באיכות גבוהה בשבילכם כדי שתהנו מהם כרגע. זה יישום הפודקאסט הטוב ביותר והוא עובד על אנדרואיד, iPhone ואינטרנט. הירשמו לסנכרון מנויים במכשירים שונים.