Add a couple numeric columns to better portray overall performance.

James William Pye · James William Pye · commit a4ee20e07817 · 2009-03-23T14:53:39.000-07:00
diff --git a/postgresql/test/perf_query_io.py b/postgresql/test/perf_query_io.py
@@ -8,10 +8,11 @@
 import os
 import time
 import sys
+import decimal
 
 def insertSamples(count, insert_records):
 	recs = [
-		(-3, 123, 0xfffffea023, 'some_&oacute;&auml;&aelig;_thing', 'varying', '&aelig;')
+		(-3, 123, 0xfffffea023, decimal.Decimal("90900023123.40031"), decimal.Decimal("432.40031"), 'some_&oacute;&auml;&aelig;_thing', 'varying', '&aelig;')
 		for x in range(count)
 	]
 	gen = time.time()
@@ -53,9 +54,9 @@ def timeTupleRead(portal):
 
 def main(count):
 	execute('CREATE TEMP TABLE samples '
-		'(i2 int2, i4 int4, i8 int8, t text, v varchar, c char)')
+		'(i2 int2, i4 int4, i8 int8, n numeric, n2 numeric, t text, v varchar, c char)')
 	insert_records = prepare(
-		"INSERT INTO samples VALUES ($1, $2, $3, $4, $5, $6)"
+		"INSERT INTO samples VALUES ($1, $2, $3, $4, $5, $6, $7, $8)"
 	)
 	select_records = prepare("SELECT * FROM samples")
 	try:
