Re: [PERFORM] planner costs in "warm cache" tests

2010-05-30 Thread Tom Lane
Jesper Krogh writes: > testdb=# set seq_page_cost = 0.1; > SET > testdb=# set random_page_cost = 0.1; > SET Well, hmm, I really doubt that that represents reality either. A page access is by no means "free" even when the page is already in cache. I don't recall anyone suggesting that you

[PERFORM] planner costs in "warm cache" tests

2010-05-30 Thread Jesper Krogh
Hi. I'm trying to get the planner to do sort of the correct thing when choosing between index-scans on btree indices and bitmap heap scans. There has been several things going on in parallel. One is that the statistics data is off: http://thread.gmane.org/gmane.comp.db.postgresql.devel.general/1