connect postgreSQL use python client very slow

[wangduanduan]

What happens?

connect db or run sql in vscode jupyter notebook is very slow

pip show duckdb
Name: duckdb
Version: 1.0.0
Summary: DuckDB in-process database
Home-page: https://www.duckdb.org

To Reproduce

import duckdb

con = duckdb.connect()
con.install_extension("postgres")
con.load_extension("postgres")

con.sql(
    f"ATTACH 'host={db_host} port={db_port} user={db_user} dbname={db_name} password={db_password}' AS db (TYPE postgres);"
)
con.sql("USE db;")

OS:

x86

DuckDB Version:

1.0.0

DuckDB Client:

python

Full Name:

eddie wang

Affiliation:

my

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have not tested with any build

Did you include all relevant data sets for reproducing the issue?

Yes

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?

• Yes, I have