iangow commented on issue #1755: URL: https://github.com/apache/arrow-adbc/issues/1755#issuecomment-4139370051
> Is it possible to confirm that your database does have a lot of OIDs? Is there a query I could run to answer your question? > Then we can try to replicate, I think. At least figure out why Python seems to be double-loading the metadata. We should also probably see if we can borrow any tricks from DuckDB. (That said, IIRC the DuckDB extension pulls some tricks that I don't think we'd want to pull.) > The driver runs this query on startup: > > SELECT > attrelid, > attname, > atttypid > FROM > pg_catalog.pg_attribute > ORDER BY > attrelid, attnum > Then it runs this a few times to try to pick up recursive structures: > > SELECT oid, typname, typreceive, typbasetype, typrelid, typarray > FROM pg_catalog.pg_type > WHERE (typreceive != 0 OR typsend != 0) AND typtype != 'r' AND typreceive::TEXT != 'array_recv' I ran both these queries using `psql` with output set to the attached (quite large) file. [oids.txt.zip](https://github.com/user-attachments/files/26291679/oids.txt.zip) -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
