duckdb / duckdb/duckdb-postgres

connect postgreSQL use python client very slow

Open
#239 0 comments 0 reactions 0 assignees View on GitHub
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

![image](https://github.com/duckdb/duckdb/assets/16631306/3c49ceea-3419-4319-944a-01074e92a707)

### 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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.