Horton

Re: Slow query: bitmap scan troubles

postgresql@foo.me.uk

View thread View on postgr.es
From: <postgresql@foo.me.uk>
To: "'postgres performance list'" <pgsql-performance@postgresql.org>
Date: 2012-12-10T09:52:42Z
Lists: pgsql-hackers, pgsql-performance 
> Greg's book is awesome. It really gives a lot of informations/tips/whatever on performances. I mostly remember all the informations about hardware, OS, PostgreSQL configuration, and such. Not much on the EXPLAIN part.

Arrived this morning :)

> http://www.pgcon.org/2010/audio/15%20The%20PostgreSQL%20Query%
> https://sites.google.com/site/robertmhaas/presentations
> http://momjian.us/main/presentations/internals.html
> http://www.dalibo.org/_media/understanding_explain.pdf

Well that is my evenings occupied for the next week. Thank you kindly.

- Phil

Commits

  1. Tweak genericcostestimate's fudge factor for index size.

  2. Tweak index costing for problems with partial indexes.