discovered an unknown park close to my father's home. he sat in the car.
ate easter brunch, also nearby. dad, give us a smile.
learned the hard way to live within ram whenever possible. touching the disk requires i/o, grinds down on speed. don't do this..
CREATE TABLE a AS SELECT ...some stuff.. FROM b WITH DATA ;
CREATE TABLE d AS SELECT ...other stuff.. FROM a WITH DATA ;
..instead, do this.
CREATE TABLE d AS ( SELECT ..other stuff.. FROM ( SELECT ..some stuff.. FROM b ) AS a ) WITH DATA ;