37 subscribers
התחל במצב לא מקוון עם האפליקציה Player FM !
פודקאסטים ששווה להאזין
בחסות


1 Grown-Up Goals: The 5 Pillars Of Being A Healthy Adult with Michelle Chalfant | 317 35:24
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
149 פרקים
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
149 פרקים
כל הפרקים
×



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