Reply-To: <guoping.zhang@nec.com.au>
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>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="hz-gb-2312"
Content-Transfer-Encoding: 7bit
Importance: Normal

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.