Re: PQconnectStart/PQconnectPoll

Craig Ringer <craig@xxxxxxxxxxxxxxx> · Thu, 22 Nov 2012 18:34:56 +0800



    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
              connection anytime I want to insert something new.
        
      
    If you mean
      that you intend to open a new connection, do a single INSERT, and
      close the connection - your performance will be awful.

      
      If your app can't use persistent or pooled connections, use
      PgBouncer as an external connection pool. Have your app connect to
      PgBouncer, and PgBouncer connect to PostgreSQL.

    
    -- 
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services