vaefremov95 commented on issue #1755: URL: https://github.com/apache/arrow-adbc/issues/1755#issuecomment-4799090052
Hi! I ran into the same problem. In my database pg_catalog.pg_attribute has about 14 million rows. On connect the driver runs this query: `SELECT attrelid, attname, atttypid FROM pg_catalog.pg_attribute ORDER BY attrelid, attnum` What I see: 1. the query takes about 2 minutes; 2. the whole catalog is loaded into memory - RAM jumps to about 3 GB right after connect, before reading any data; 3. the ORDER BY creates about 2 GB of spill files on the server while the query runs. Is there any update on the status of this issue? Thanks! -- 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]
