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/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
I guess you are hitting this bug: http://www.postgresql.org/message-id/15290.1435103...@sss.pgh.pa.us Fixed in this commit: http://www.postgresql.org/message-id/e1z8c3z-0004ko...@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