Slow count | Postgres.FM 114 |

[ 🇬🇧_🇺🇸 Check out the subtitles - we now edit them, ChatGPT+manually! You can also try RUclips's auto-translation of them from English to your language; try it and share it with people interested in Postgres!]
Nikolay and Michael discuss why counting can be slow in Postgres, and what the options are for counting things quickly at scale.
Here are some links to things they mentioned:
* Aggregate functions (docs) www.postgresql...
* PostgREST github.com/Pos...
* Get rid of count by default in PostgREST github.com/Pos...
* Faster PostgreSQL Counting (by Joe Nelson on the Citus blog) www.citusdata....
* Our episode on Index-Only Scans postgres.fm/ep...
* Postgres HyperLogLog github.com/cit...
* Our episode on Row estimates postgres.fm/ep...
* Our episode about dangers of NULLs postgres.fm/ep...
* Aggregate expressions, including FILTER www.postgresql...
* Spread writes for counter cache (tip from Tobias Petry) x.com/tobias_p...
* pg_ivm extension (Incremental View Maintenance) github.com/sra...
* pg_duckdb announcement motherduck.com...
* Our episode on Queues in Postgres postgres.fm/ep...
* Our episode on Real-time analytics postgres.fm/ep...
* ClickHouse acquired PeerDB clickhouse.com...
* Timescale Continuous Aggregates www.timescale....
* Timescale editions docs.timescale...
* Loose indexscan wiki.postgresq...
~~~
What did you like or not like? What should we discuss next time? Let us know in the comments, or by tweeting us on @postgresfm / postgresfm , @samokhvalov / samokhvalov and @michristofides / michristofides
~~~
Postgres FM is produced by:
- Nikolay Samokhvalov, founder of Postgres.ai postgres.ai/
- Michael Christofides, founder of pgMustard pgmustard.com/
~~~
This is the video version. Check out postgres.fm to subscribe to the audio-only version, to see the transcript, guest profiles, and more.