Postgres not using your index? It’s counting pages, not rows

Byali

Nov 13, 2026 #SQL

Postgres not using your index? It’s counting pages, not rows

You get a Seq Scan even with an index because the planner prices a query in pages, and a small table is cheaper to read whole.

Continue reading on Medium »

Postgres not using your index? It's counting pages, not rows You get a Seq Scan even with an index because the planner prices a query in pages, and a small table is cheaper to read whole.Continue reading on Medium » Read More Sql on Medium

#sql

By ali

SQL

Postgres not using your index? It’s counting pages, not rows

Nov 13, 2026 ali

SQL

Using Claude to Write Postgres Schema Changes: 4 Ways an ALTER TABLE Blocks Your App, Tested on 2…

Nov 13, 2026 ali

SQL

Using Claude to Write Postgres Schema Changes: 4 Ways an ALTER TABLE Blocks Your App, Tested on 2…

Nov 13, 2026 ali

M	T	W	T	F	S	S
						1
2	3	4	5	6	7	8
9	10	11	12	13	14	15
16	17	18	19	20	21	22
23	24	25	26	27	28	29
30

Postgres not using your index? It’s counting pages, not rows

Byali

By ali

Related Post

Postgres not using your index? It’s counting pages, not rows

Using Claude to Write Postgres Schema Changes: 4 Ways an ALTER TABLE Blocks Your App, Tested on 2…

Using Claude to Write Postgres Schema Changes: 4 Ways an ALTER TABLE Blocks Your App, Tested on 2…

Leave a Reply Cancel reply

You missed

Spock Framework in Spring Boot — Write Cleaner Unit and Integration Tests with Java 25

Spock Framework in Spring Boot — Write Cleaner Unit and Integration Tests with Java 25

Stop Animating Custom Properties Blind — Register Them with @property

Stop Animating Custom Properties Blind — Register Them with @property

Alicloud.my.id