Скачать или смотреть 5mins of Postgres E47: Roaring Bitmaps & pgfaceting: Fast counting across large datasets in Postgres

Today, we talk about counting and faceting large result sets using Roaring Bitmaps in Postgres. We are looking at the pg_roaringbitmap extension and the pgfaceting extension which help us improve our query performance from 222 seconds to 155 milliseconds.

Find the article on our blog here:
https://pganalyze.com/blog/5mins-post...

Learn more about pganalyze:
https://pganalyze.com
https://pganalyze.com/newsletter
  / pganalyze  

Check out the pganalyze library for eBooks, webinars, and more:
https://pganalyze.com/resources

📑 What we have discussed in this episode of 5mins of Postgres:

Faceting large result sets in PostgreSQL
https://www.cybertec-postgresql.com/e...

Ants Aasma on GitHub
https://github.com/ants

Roaring Bitmaps - A better compressed bitset
https://roaringbitmap.org/about/

Chen Huajun on GitHub
https://github.com/ChenHuajun

pg_roaringbitmap - GitHub repository
https://github.com/ChenHuajun/pg_roar...

pgfaceting - GitHub repository
https://github.com/cybertec-postgresq...