Marco Pegoraro
  • About Me
  • Communication
  • Tutorials
  • Tips & Tricks
Subscribe
Tagged

performance

A collection of 1 post

How to optimize Postgres for SELECT COUNT(*) on massive tables
Tips & Tricks

How to optimize Postgres for SELECT COUNT(*) on massive tables

How to (slightly) optimize SELECT COUNT(*) performance on PostgreSQL using partial indexes.

  • Marco Pegoraro
Marco Pegoraro Dec 3, 2017 • 3 min read
Marco Pegoraro © 2022
  • Privacy
  • Cookies
Powered by Ghost