Drop down in connect time between 9.3.6 and 9.3.9 ?
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Marc Mamin wrote:
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/nullreal 0m4.994s
user 0m0.088s
sys 0m0.272s9.3.9:
time { i=0; while [ $i -lt 1000 ]; do let i++; psql -c 'select 1' ; done; } >/dev/nullreal 0m11.081s
user 0m0.140s
sys 0m0.208s
I guess you are hitting this bug:
/messages/by-id/15290.1435103076@sss.pgh.pa.us
Fixed in this commit:
/messages/by-id/E1Z8C3Z-0004Ko-1h@gemulon.postgresql.org
You could apply the patch on your system if necessary.
Yours,
Laurenz Albe
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general