GP Sanity Test

Posted by scottk on August 24, 2010 in Ramblings | ∞

New Greenplum instance running. Loaded 2 billion randomly generated rows equating to about 250G of data in 30 minutes. Analyze table and query on a non-indexed field.

select count(1) from skahler.load_test where smallcode like ‘__A_’;
count
———-
76940782
(1 row)