中文 English Français Русский Español العربية

Christophe Pettus: All Your GUCs in a Row: random_page_cost and seq_page_cost

Planet PostgreSQL2026-10-18 09:000 views

The planner charges `random_page_cost` per index page based on how uncorrelated the index is—but the name lies. (I consult on PostgreSQL through PGX Inc..)

Source：https://postgr.es/p/9yN

My favorites

PreviousCircuitCraft: a Rust desktop circuit editor with ngspice simulation NextShow HN: Alley Cat Band – An Android rhythm game starring a punk band of cats

SOLID Principles Explained: 5 Essential Principles for Writing Clean, Maintainable Code

SOLID principles are a set of five fundamental object-oriented design principles that help developers build software tha

0dev.to Tutorial

How to Build a Professional Resume in 2026: Best Resume Formats, Templates, and ATS Tips

Creating a professional resume is one of the most important steps when looking for a new job. However, many job seekers

0dev.to Career

How to Explain Your Project in a Technical Interview

"Walk me through a project you worked on" is one of the most common questions in technical interviews. It is also where

0dev.to Career

Stop Calling It "Refactoring" When You Are Just Moving The Bugs Around

Let's talk about the ultimate corporate tech delusion: the quarterly "code cleanup" or what senior developers love to pr

0dev.to Career

PostgreSQL migrations that lock a busy table

Which schema changes in PostgreSQL block reads or writes on a live table, why each one does, and the safer sequence of s

0dev.to Testing

🧠 Do Prompt ao RAG: como fazer um LLM responder sem inventar (e sem processo do cliente)

E aí, dev que já viu uma IA inventar uma política de reembolso que não existe? Ou pior: prometer um recurso que o produt

0dev.to Java

Christophe Pettus: All Your GUCs in a Row: random_page_cost and seq_page_cost

Related posts

SOLID Principles Explained: 5 Essential Principles for Writing Clean, Maintainable Code

How to Build a Professional Resume in 2026: Best Resume Formats, Templates, and ATS Tips

How to Explain Your Project in a Technical Interview

Stop Calling It "Refactoring" When You Are Just Moving The Bugs Around

PostgreSQL migrations that lock a busy table

🧠 Do Prompt ao RAG: como fazer um LLM responder sem inventar (e sem processo do cliente)