X-Original-To: pgsql-performance-postgresql.org@postgresql.org Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 74DEE9FA65C for ; Wed, 19 Jul 2006 11:18:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 71592-03-2 for ; Wed, 19 Jul 2006 14:18:08 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx00.ext.bfk.de (mx00.ext.bfk.de [217.29.46.125]) by postgresql.org (Postfix) with ESMTP id 02A6F9FA621 for ; Wed, 19 Jul 2006 11:18:07 -0300 (ADT) Received: from fweimer by bfk.de with local id 1G3CsF-0006eR-Mq; Wed, 19 Jul 2006 16:18:03 +0200 To: Guoping Zhang Cc: pgsql-performance@postgresql.org Subject: Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance? References: <82irlu2jk9.fsf@mid.bfk.de> <003501c6ab05$a4978f20$74304c93@eddy> <20060719140135.GE20016@kenobi.snowman.net> From: Florian Weimer Date: Wed, 19 Jul 2006 16:18:03 +0200 In-Reply-To: <20060719140135.GE20016@kenobi.snowman.net> (Stephen Frost's message of "Wed, 19 Jul 2006 10:01:35 -0400") Message-ID: <82bqrl1xwk.fsf@mid.bfk.de> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/194 X-Sequence-Number: 20054 * Stephen Frost: > Actually, can't you stick multiple inserts into a given 'statement'? > ie: insert into abc (123); insert into abc (234); IIRC, this breaks with PQexecParams, which is the recommended method for executing SQL statements nowadays. -- Florian Weimer BFK edv-consulting GmbH http://www.bfk.de/ Durlacher Allee 47 tel: +49-721-96201-1 D-76131 Karlsruhe fax: +49-721-96201-99