Hi,
Sorry, I forgot to include the initialization SQL.
drop table if exists pg_class_1;
drop table if exists pg_class_2;
select max(oid) from pg_catalog.pg_class;
create table pg_class_1 as select * from pg_catalog.pg_class where oid < 13673
WITH DATA;
create table pg_class_2 as select * from pg_class_1 WITH DATA;
analyze pg_class_1, pg_class_2;
select count(*) from pg_class_1;
select count(*) from pg_class_2;
explain (summary) select a.reltype from pg_class_1 a, pg_class_1 b where
a.reltype = b.reltype;
explain (summary) select a.reltype from pg_class_1 a, pg_class_2 b where
a.reltype = b.reltype;
regards,
--
ZizhuanLiu (X-MAN)
[email protected]
