close connection more expensive that open connection?

From: Rob Sargent <rsargent(at)xmission(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: close connection more expensive that open connection?
Date: 2011-03-03 00:13:51
Message-ID: 4D6EDD3F.5090504@xmission.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

A developer here accidentally flooded a server with connection opens and
closes, essentially one per transaction during a multi-threaded data
migration process.

We were curious if this suggests that connection clean up is more
expensive than creation thereby exhausting resources, or if perhaps the
server wasn't returning to the essentially backgrounded clean-up task
adroitly (enough)?

Don't worry we are now using a connection pool for the migration, but
the situation was, um, er, entertaining. The server side said
eof-from-client, the client side said many variations of cannot-connect,
then they would work out their differences briefly and do the same dance
over again after sufficient connections.

Cheers,
rjs

Browse pgsql-general by date

  From Date Subject
Next Message Jasmin Dizdarevic 2011-03-03 01:01:19 Re: PG on two nodes with shared disk ocfs2 & drbd
Previous Message Merlin Moncure 2011-03-02 23:50:25 Re: how to avoid repeating expensive computation in select