:

ROWS=100000
COLSIZE=2500

echo "
	DROP TABLE test;
	CREATE TABLE test(i SERIAL, t text);
	INSERT INTO test (t)
	SELECT	array_to_string(ARRAY(
		SELECT chr(32 + (95 * random())::integer)
		FROM generate_series(1,$COLSIZE)),'')
	FROM	generate_series(1, $ROWS);
	SELECT 	pg_relation_size('test') AS "HEAP",
		pg_total_relation_size('test') - pg_relation_size('test') AS "TOAST";
	SET log_min_duration_statement = 0;
	SET client_min_messages = 'log';
	SELECT t FROM test WHERE i = 234329823;" | 
sql test