PG_ATTACH takes very long to execute

[dberardo-com]

What happens?

The pg_attach method takes quite long to execute. is there any way to speed that up?

To Reproduce

i am using pg_attach on a patroni replica on a server that has many DBs, but only attaching to a specific one. The query sometimes even a minute or more to return.

i have perhaps 20 or 30 tables in this DB, but with really few 100 of rows per table.

Is there any way i can debug / speed up the process ?

OS:

linux

PostgreSQL Version:

14

DuckDB Version:

0.7.1

DuckDB Client:

python

Full Name:

check other issues

Affiliation:

check other issues

Have you tried this on the latest master branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree

[Mytherin]

Thanks for the report! This should be addressed now in #111 using the new ATTACH syntax.