if createIndexes: result = Result() result.method = "pgsql-Idx" result.tag = tag rsidIndex = "CREATE UNIQUE INDEX idx_rsid ON snp (rsid)" clinIndex = "CREATE INDEX idx_clin ON snp (has_sig)" geneIndex = "CREATE INDEX idx_gene ON locus (gene)" 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()