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()
