PostgreSQL - 高速でINSERTしたい君へ - Qiita

import psycopg2 from psycopg2.extras import execute_values from time import time _text = 'test' * 300 conn = psycopg2.connect('dbname=dbname host=localhost user=username password=password') cur = conn.cursor() # テーブルリセット reset_query_tbl = "TRUNCATE TABLE test01;" cur.execute(reset_query_tbl) reset_query_seq = "SELECT setval ('test01_key_seq', 1, false);" cur.execute(reset_query_seq) count_query =

[takryou79]

psycopg2