Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?

From:	"Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To:	"Scott Carey" <scott(at)richrelevance(dot)com>, "Mladen Gogala" <mladen(dot)gogala(at)vmsinfo(dot)com>
Cc:	"pgsql-performance(at)postgresql(dot)org Performance" <pgsql-performance(at)postgresql(dot)org>, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject:	Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why?
Date:	2010-10-19 15:16:31
Message-ID:	4CBD6FFF0200002500036B27@gw.wicourts.gov
Views:	Raw Message | Whole Thread | Download mbox | Resend email
Thread:	2010-10-19 01:40:11 from Scott Carey <scott(at)richrelevance(dot)com>  2010-10-19 03:43:45 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>   2010-10-19 09:00:11 from Scott Carey <scott(at)richrelevance(dot)com>    2010-10-19 14:22:42 from Mladen Gogala <mladen(dot)gogala(at)vmsinfo(dot)com>     2010-10-19 15:16:31 from "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>  2010-10-27 02:56:07 from Robert Haas <robertmhaas(at)gmail(dot)com>   2010-10-27 03:48:04 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>    2010-10-27 19:25:42 from Scott Carey <scott(at)richrelevance(dot)com>     2010-10-27 19:56:19 from Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Lists:	pgsql-performance

In response to

• Re: HashJoin order, hash the large or small table? Postgres likes to hash the big one, why? at 2010-10-19 14:22:42 from Mladen Gogala

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Jon Nelson	2010-10-19 15:27:48	Re: odd postgresql performance (excessive lseek)
Previous Message	Tom Lane	2010-10-19 14:36:09	Re: odd postgresql performance (excessive lseek)