duckdb / duckdb/duckdb-postgres
connect postgreSQL use python client very slow
- Dominant language
- C++
- Stars
- 372
- Forks
- 105
- Avg merge
- 10h 19m
- Merged PRs (30d)
- 18
Description
### 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
```python
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?
- [X] Yes, I have
### Did you include all relevant configuration (e.g., CPU architecture, Python version, Linux distribution) to reproduce the issue?
- [X] Yes, I have
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.