Skip site navigation (1) Skip section navigation (2)

Estimation of HashJoin Cost

From: Qi Huang <huangqiyx(at)outlook(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Estimation of HashJoin Cost
Date: 2012-11-01 08:46:10
Message-ID: BAY002-W113E83F4A3E58D76176305B0600@phx.gbl (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi, Dear Hackers    I need to estimate the hashjoin cost in my research. As the textbook shows, it is 3(R+S) where R and S are the size of the tablesize of the two tables, which realistically only considers the cost of IO. But this is obviously too theoretical. What is the correct way to estimate the cost of hashjoin? I looked at the code of final_cost_hashjoin() . It is not clear what factor it is considering. So, except the I/O to and from disk, what other factors are affecting the cost of hahsjoin?     Also, is there any way to force postgres abide on the estimation of Hashjoin cost as 3(R+S), which also means, to make hashjoin cost mainly spend on I/O?
Thanks

Best RegardsHuang Qi VictorComputer Science of National University of Singapore 		 	   		  

pgsql-hackers by date

Next:From: Mark KirkwoodDate: 2012-11-01 10:08:09
Subject: Re: Autoanalyze of the autovacuum daemon ...
Previous:From: Amit kapilaDate: 2012-11-01 07:35:04
Subject: Re: Proposal for Allow postgresql.conf values to be changed via SQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group