Re: WTF with hash index?

Am 13.11.2018 um 17:42 schrieb Олег Самойлов:
> insert into gender (gender) select case when random<0.50 then 'female' 
> when random<0.99 then 'male' else 'other' end from (select random() as 
> random, generate_series(1,:table_size)) as subselect;

is that really your intended data distibution? 99% male?

Regards, Andreas
-- 

2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com