Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for some up-to-date information about postgresql internals, specifically the query optimizer. I've found this link (referred to in the "Further Reading" section of the 8.4 docs):-

but it seems quite old. That in itself is not a problem, but I wanted to be sure that I have information that is relevant. Is this the best resource for understanding how postgresql processes queries (using plans, statistics etc.) or are there others?

share|improve this question
up vote 4 down vote accepted

The Postgres documentation is the best source for the most up-to-date information on how the system works -- second only to the code itself.

That being said, Your link is still valid for reference. There's also and all of section VII of the manual @ (Chapters 44, 50 & 56 may be of particular interest to you).

If you're looking for something more specific than that you'll have to narrow the scope of your question a bit more -- The query planner/optimizer is a pretty complex area and you really need to put a sharp point on your questions to avoid getting buried in information :-)

share|improve this answer
just what I was looking for - thank you! – NogginTheNog Jan 11 '11 at 10:41

src/backend/optimizer/README contains a lot of information. Many source files under that directory also contain big comments. That's about as up-to-date and relevant as you can hope for.

share|improve this answer
Forgot about the optimizer readme -- good call. – voretaq7 Jan 10 '11 at 17:56

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.