lidavidm opened a new issue, #4749: URL: https://github.com/apache/arrow-adbc/issues/4749
### What feature or improvement would you like to see? As suggested at https://github.com/apache/arrow-adbc/issues/1755#issuecomment-4837266338 we could reduce the amount of data being queried at startup to build the type mapping table. One involves not querying _every single column_ in the database. An alternate suggested query: ```sql SELECT a.attrelid, a.attname, a.atttypid FROM pg_catalog.pg_attribute AS a JOIN pg_catalog.pg_type AS t ON t.typrelid = a.attrelid WHERE t.typtype = 'c' AND a.attnum > 0 AND NOT a.attisdropped ORDER BY a.attrelid, a.attnum ``` We should add a full suite of tests for different scenarios first, though, to ensure we don't break one of them (e.g. inherited tables), also we should benchmark (both time to connect and CPU usage), and perhaps expose some controls/statistics about the type table (# of entries, time to build, flush/rebuild, etc.) -- 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]
