Re: [PERFORM] PQconnectStart/PQconnectPoll

2012-11-22 Thread Craig Ringer
On 11/15/2012 05:02 PM, Sergio Mayoral wrote: > > PQconnectdb is taking too long comparing to mysql and i found out the > time is consumed by PQconnectPoll waiting for the socket to be ready > for reading/writing What's "too long"? > > I cannot use persistent connections. I must open/close a connec

Re: [PERFORM] PQconnectStart/PQconnectPoll

2012-11-20 Thread Kevin Grittner
Sergio Mayoral wrote: > I cannot use persistent connections. I must open/close a connection > anytime I want to insert something new. That's odd. Why is that? > do i have to configure something different? Am i missing something? You could use pgbouncer to hold database connections open for you