问 Postgres包: psycopg2 copy_from vs copy_expert

EN

我的实现将 copy_from 更改为 copy_expert 。对PostgreSQL负载的广泛分析可以在这里找到： https://hakibenita.com/fast-load-data-python-postgresql 。

COPY_FROM

def insert_with_string_io(df: pd.DataFrame, table_name: str):
        buffer = io.StringIO()
        df.to_csv(buffer, index=False, header=False)
        buffer.seek(0)
        with conn.cursor() as cursor:
                cursor.copy_from(file=buffer, table=table_name, sep=",", null="")
            except (Exception, psycopg2.DatabaseError) as error:
                print("Error: %s" % error)

COPY_EXPERT

def insert_with_string_io(df: pd.DataFrame):
        buffer = io.StringIO()
        df.to_csv(buffer, index=False, header=False)