Re: Performance with the new security release?

Hi Josh,
Thanks for your reply.
I don't think this is the case since we are using jboss/jdbc driver with a connection pool.

Thanks,
Anne

-----Original Message-----
From: Josh Berkus [mailto:josh(at)agliodbs(dot)com]
Sent: Monday, April 22, 2013 10:58 AM
To: Anne Rosset
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] Performance with the new security release?

On 04/22/2013 10:38 AM, Anne Rosset wrote:
> While we are digging into this, I would like to know if it is
> possible that the release has some impact on performance. After
> reading this "It was created as a side effect of a refactoring effort
> to make establishing new connections to a PostgreSQL server faster,
> and the associated code more maintainable.", I am thinking it is quite possible.

Does your application do a lot of rapidfire reconnection to the database? As in hundreds of new connections per minute?

Mind you, if it does, I strongly recommend pgbouncer ...

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com