Drop down in connect time between 9.3.6 and 9.3.9 ?

From: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Drop down in connect time between 9.3.6 and 9.3.9 ?
Date: 2015-07-22 10:50:59
Message-ID: B6F6FD62F2624C4C9916AC0175D56D8828C16690@jenmbs01.ad.intershop.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,
We've just upgraded some productive servers from 9.3.6 to 9.3.9, and it seems that the time to get a connection (or possibly to disconnect) has become much slower.
These tests are consistent when run against different servers.

tests with 9.4.1 show fast times, but we don't have a later version to test yet.

Is this a known issue ?

9.3.6:
time { i=0; while [ $i -lt 1000 ]; do let i++; psql -c 'select 1' ; done; } >/dev/null

real 0m4.994s
user 0m0.088s
sys 0m0.272s

9.3.9:
time { i=0; while [ $i -lt 1000 ]; do let i++; psql -c 'select 1' ; done; } >/dev/null

real 0m11.081s
user 0m0.140s
sys 0m0.208s

regards,

Marc Mamin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2015-07-22 11:18:22 Re: Drop down in connect time between 9.3.6 and 9.3.9 ?
Previous Message Fritz Meissner 2015-07-22 10:18:59 Re: Cannot reach pg server using -h localhost