Oliver Seidel writes:
> I have
> create table x ( att bigint, val bigint, hash varchar(30)
> );
> with 693million rows. The query
> create table y as select att, val, count(*) as cnt from x
> group by att, val;
> ran for more than 2000 minutes and used 14g memory on
Hi,
I have
create table x ( att bigint, val bigint, hash varchar(30)
);
with 693million rows. The query
create table y as select att, val, count(*) as cnt from x
group by att, val;
ran for more than 2000 minutes and used 14g memory on an 8g physical
RAM machine -
