Skip to content

DEV Community

Aggregates in YugabyteDB Series' Articles

Back to Franck Pachot's Series

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Dec 7 '22

Partial Index as an approximate Count(*) Materialized View

#yugabytedb #postgres #aggregate #database

3 min read

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

May 24 '23

Parallel Scan in YugabyteDB (ysql_select_parallelism=-1)

#yugabytedb #distributed #sql #database

3 min read

May 25 '23

Approximate Count for hash sharded YugabyteDB tables

#yugabytedb #postgres #distributed #sql

4 min read

Cover image for Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Jun 30 '23

Approximate Count Distinct in YugabyteDB (and PostgreSQL) with HyperLogLog

#yugabytedb #postgres #distributed #sql

6 min read

Cover image for Fast SELECT COUNT(*) WHERE in YugabyteDB

Franck Pachot for YugabyteDB Distributed PostgreSQL Database

Oct 22 '23

Fast SELECT COUNT(*) WHERE in YugabyteDB

#yugabytedb #distributed #sql #postgres

5 min read