From: Guoping Zhang <guoping.zhang@nec.com.au>
To: pgsql-performance@postgresql.org
Cc: Guoping Zhang (E-mail) <guopingz@nstc.nec.com.au>
Subject: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
Date: Wed, 19 Jul 2006 15:40:02 +1000
Message-ID: <003401c6aaf5$c8c2d900$74304c93@eddy> (raw)
Hello,
I am seeking advice/comment/experience you may have had for the performance
cost for remote access to postgresql 8.1.X?
I have two servers, one is Sun V240 (say server A) and the other is dual
intel Xeon (say Server B) and both installed Solaris 10.
With Server A, there is postgresql 8.1.3 installed with pgpool
(pgpool-3.0.2), with server B, there is a pgpool (v3.0.2) installed.
The test program is installed on both A and B, where the test application on
server B is accessing to DBMS on A through pgpool.
Note that the test code is not fancy but can insert a large number of record
(say 100k rows) with configurable transaction size.
Following are the results (repeated many times with the mean value and shall
be accurate) for various setting by fixed 100k insertion operation with a
transaction size as 100 rows):
------------------------------------------
1. Test program running on server A directly access to LOCAL postgresql:
24.03 seconds
2. Test progam running on server A access to LOCAL postgresql through
pgpool: 30.05 seconds
3. Test progam running on server A access REMOTE postgresql through local
pgpool: 74.06 seconds
------------------------------------------
I have to say both machines are very light load and interconnected with
local LAN.
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: guoping.zhang@nec.com.au, guopingz@nstc.nec.com.au
Subject: Re: Performance penalty for remote access of postgresql (8.1.3)? any experiance?
In-Reply-To: <003401c6aaf5$c8c2d900$74304c93@eddy>
* 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