Re: [GENERAL] hash join performance question

2017-07-20 Thread armand pirvu
> On Jul 18, 2017, at 10:30 PM, Tom Lane wrote: > > armand pirvu writes: >> testdb3=# explain analyze SELECT a.company_id FROM csischema.dim_company a, >> woc.dim_company b >> testdb3-# WHERE a.company_id = b.company_id; >> QUERY PLAN

Re: [GENERAL] hash join performance question

2017-07-18 Thread Tom Lane
armand pirvu writes: > testdb3=# explain analyze SELECT a.company_id FROM csischema.dim_company a, > woc.dim_company b > testdb3-# WHERE a.company_id = b.company_id; > QUERY PLAN >

[GENERAL] hash join performance question

2017-07-18 Thread armand pirvu
Hi testdb3=# \d csischema.dim_company; Table "csischema.dim_company" Column |Type | Modifiers -+-+--- company_id | integer | not null company_name| character varying