print "Creating RSID index..." sys.stdout.flush() idxStart = time.time() cursor.execute(rsidIndex) postgresConnection.commit() idxEnd = time.time() result.idxRsid = idxEnd - idxStart print "Creating ClinSig index..." sys.stdout.flush() idxStart = time.time() cursor.execute(clinIndex) postgresConnection.commit() idxEnd = time.time() result.idxClinSig = idxEnd - idxStart print "Creating Gene index..." sys.stdout.flush() idxStart = time.time() cursor.execute(geneIndex) postgresConnection.commit() idxEnd = time.time() result.idxGene = idxEnd - idxStart resultsFile.write(result.toString() + '\n') # Run queries if requested in args if runQueries: for z in range(1,11): result = Result()