eqseltest1-log.sql

text/plain

Filename: eqseltest1-log.sql

Type: text/plain

Part: 0

Message: Re: Use merge-based matching for MCVs in eqjoinsel

drop table if exists tint1, tint2, ttext1, ttext2;

CREATE COLLATION ignore_accent_case (provider = icu, deterministic = false, locale = 'und-u-ks-level1');

create table tint1 as
  select (-log(random())*10000)::int as x from generate_series(1,1000000);
create table tint2 as
  select (-log(random())*10000)::int as x from generate_series(1,1000000);

create table ttext1 (x text collate ignore_accent_case);
insert into ttext1
  select md5((-log(random())*10000)::int::text) as x from generate_series(1,1000000);

create table ttext2 (x text collate ignore_accent_case);
insert into ttext2
  select md5((-log(random())*10000)::int::text) as x from generate_series(1,1000000);