You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@arrow.apache.org by "wonb168 (via GitHub)" <gi...@apache.org> on 2025/03/25 01:49:07 UTC

[I] cost 98s to connect to greenplum [arrow-adbc]

wonb168 opened a new issue, #2647:
URL: https://github.com/apache/arrow-adbc/issues/2647

   ### What happened?
   
   why new a connection to gp need 98 second？
   
   
   ### Stack Trace
   
   when connect to gp,
   adbc will read all tables to get column types?
   how to speed connect to gp?
   
   ### How can we reproduce the bug?
   
   ```
   import os
   import time
   import adbc_driver_postgresql.dbapi
   
   #uri = os.environ["ADBC_POSTGRESQL_TEST_URI"]
   t=time.time()
   conn = adbc_driver_postgresql.dbapi.connect(uri)
   print(time.time()-t)
   with conn.cursor() as cur:
       cur.execute("SELECT 1")
       print(cur.fetchone())
       # Output: (1,)
   
   conn.close()
   ```
   
   ### Environment/Setup
   
   greeplum 6.12(postgres 9.4)
   server: centos7.9
   client: macos
   python:3.11.9
   package manager: pip
   adbc-driver-manager                               1.0.0
   adbc-driver-postgresql                            1.2.0


-- 
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: issues-unsubscribe@arrow.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] cost 98s to connect to greenplum [arrow-adbc]

Posted by "lidavidm (via GitHub)" <gi...@apache.org>.
lidavidm commented on issue #2647:
URL: https://github.com/apache/arrow-adbc/issues/2647#issuecomment-2749851001

   I believe you're likely running into this? https://github.com/apache/arrow-adbc/issues/1755
   
   I still have it on my backlog to take a look at improving this but haven't had much time


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

Re: [I] cost 98s to connect to greenplum [arrow-adbc]

Posted by "wonb168 (via GitHub)" <gi...@apache.org>.
wonb168 commented on issue #2647:
URL: https://github.com/apache/arrow-adbc/issues/2647#issuecomment-2752936757

   my greenplum has so many objects，if I connect to small gp，less then 10s，but use psycopg2 to connect，less then 0.1s


-- 
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: github-unsubscribe@arrow.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org