From: Stephen Frost <sfrost@snowman.net>
To: Guoping Zhang <guoping.zhang@nec.com.au>
Cc: Florian Weimer <fweimer@bfk.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
Date: Wed, 19 Jul 2006 10:01:35 -0400
Message-ID: <20060719140135.GE20016@kenobi.snowman.net> (raw)
In-Reply-To: <003501c6ab05$a4978f20$74304c93@eddy>
References: <82irlu2jk9.fsf@mid.bfk.de>
<003501c6ab05$a4978f20$74304c93@eddy>
* Guoping Zhang (guoping.zhang@nec.com.au) wrote:
> Obviously, if there is no better solution, the TCP round trip penalty will
> stop us doing so as we do have performance requirement.
Actually, can't you stick multiple inserts into a given 'statement'?
ie: insert into abc (123); insert into abc (234);
I'm not 100% sure if that solves the round-trip issue, but it might..
Also, it looks like we might have multi-value insert support in 8.2 (I
truely hope so anyway), so you could do something like this:
insert into abc (123),(234);
> I guess there shall be quite number of people out there facing the similar
> problem, right? No alternative solution?
Havn't run into it myself... Quite often you either have large inserts
being done using COPY commands (data warehousing and analysis work) or you
have a relatively small number of one-off inserts (OLTP) per transaction.
Enjoy,
Stephen
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sfrost@snowman.net, guoping.zhang@nec.com.au, fweimer@bfk.de
Subject: Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
In-Reply-To: <20060719140135.GE20016@kenobi.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox