Received: from magus.postgresql.org ([87.238.57.229]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1Tao2C-00088Y-Tb for pgsql-performance@postgresql.org; Tue, 20 Nov 2012 13:38:40 +0000 Received: from mailout-us.gmx.com ([74.208.5.67] helo=mailout-us.mail.com) by magus.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1Tao2A-0007wc-6U for pgsql-performance@postgresql.org; Tue, 20 Nov 2012 13:38:40 +0000 Received: (qmail 4865 invoked by uid 0); 20 Nov 2012 12:57:26 -0000 Received: from 76.255.19.161 by rms-us006 with HTTP Content-Type: text/plain; charset="utf-8" Date: Tue, 20 Nov 2012 07:57:23 -0500 From: "Kevin Grittner" Message-ID: <20121120125723.156400@gmx.com> MIME-Version: 1.0 Subject: Re: PQconnectStart/PQconnectPoll To: "Sergio Mayoral" ,"postgresql-perf" X-Authenticated: #138763884 X-Flags: 0001 X-Mailer: GMX.com Web Mailer x-registered: 0 Content-Transfer-Encoding: 8bit X-GMX-UID: ZBvZcHxc3zOlOQ09Lnwhbxt+IGRvb0Ab X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201211/204 X-Sequence-Number: 48570 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 and provide a somewhat more lightweight connection process. -Kevin