Re: Azure Postgresql High connection establishment time

2021-09-20 Thread Peter J. Holzer
On 2021-09-20 13:37:52 -0400, Abhay Gupta wrote: > Yes, Azure postgresql has a private endpoint attached to it so it is going > through a private link. Also the server has 2 vcore and 5gb. Since currently > we > are in development phase there is no load on the server at all. No encryption > and in

Re: Azure Postgresql High connection establishment time

2021-09-20 Thread Adrian Klaver
On 9/20/21 10:37 AM, Abhay Gupta wrote: Hello Tom Thanks for taking time in looking into this for us. Apologies for not providing any required data. Yes, Azure postgresql has a private endpoint attached to it so it is going through a private link. Also the server has 2 vcore and 5gb. Since

Re: Azure Postgresql High connection establishment time

2021-09-20 Thread Abhay Gupta
Hello Tom Thanks for taking time in looking into this for us. Apologies for not providing any required data. Yes, Azure postgresql has a private endpoint attached to it so it is going through a private link. Also the server has 2 vcore and 5gb. Since currently we are in development phase there is

Re: Azure Postgresql High connection establishment time

2021-09-20 Thread Tom Lane
Abhay Gupta writes: > we are noticing the connection establishment is taking around 200-300 ms. Not sure whether that's out of line or not, since you've provided no background data (e.g. is the connection across a network link? how busy is the server? what encryption and authentication are you us

Re: Azure Postgresql High connection establishment time

2021-09-20 Thread Michael Lewis
This is not a Postgres issue. Please reach out to the Azure team. >

Azure Postgresql High connection establishment time

2021-09-20 Thread Abhay Gupta
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(con