Azure Postgresql High connection establishment time

From: Abhay Gupta <gupta(dot)abhay86(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Azure Postgresql High connection establishment time
Date: 2021-09-20 12:58:21
Message-ID: CACpkcfw2+OB=B17-DkNC8erAPALYPLErK2opGv6LhKWU+L6f6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

we are writing a python(3.9) azure function hosted on linux which is
connecting to azure postgresql 11. We are using psycopg2 to connect the
azure function to postgresql.

we are noticing the connection establishment is taking around 200-300 ms.
Below is the statment.

conn=psycopg2.connect(conn_string)

Conn_string includes host, user, password, dbname, sslmode=require

The connection establishment time is very high as our functions are written
to be very high performance.

can you please let us know if there is something we should be doing to
reduce the connection establishment time.

Thanks

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2021-09-20 13:18:17 Re: Possibilities for optimizing inserts across oracle_fdw foreign data wrapper
Previous Message ramikvl 2021-09-20 11:46:07 Re: jsonb Indexing