Tag feed

#db-performance

2 posts0 followers

Postgres Missing Statistics - A quick fix for a big problem

Feb 7, 2023 · 5 min read · What are Postgres Statistics? The statistics collect information about count accesses to tables and indexes in both disk block and individual row terms. It also tracks the total number of rows in each table, and information about vacuum, and analyzes...

Join discussion

IBItay Braunpostgres.hashnode.dev

1

Reading Postgres Execution Plans doesn't have to be so complicated

Nov 6, 2022 · 7 min read · By Itay Braun, CTO, Metis Main Subjects What is an Execution Plan. Key differences between the Actual and Estimated ones. As a backend developer, why should you care, even if an ORM is used and you don't control the SQL. A curated list of great...

AAlex commented

#db-performance

Search Hashnode

#db-performance

Postgres Missing Statistics - A quick fix for a big problem

Reading Postgres Execution Plans doesn't have to be so complicated