Postgres network preformance

From: Ferdinand Smit <ferdinand(at)telegraafnet(dot)nl>
To: pgsql-admin(at)postgresql(dot)org
Subject: Postgres network preformance
Date: 2002-06-07 12:20:46
Message-ID: 200206071420.46460.ferdinand@telegraafnet.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

Does anyone have any tips to improve the network preformance op Postgres ?

To test the preformance i've done a little test using the perlmodule DBI.
The ping last 1 ms and the computers are identical.

The test script:

#!/usr/bin/perl
use DBI;

my $connectTo = "dbi:Pg:dbname=testdb;host=obelix.telegraaf.net";
my $dbh = DBI->connect($connectTo,undef,undef,undef) or die("$DBI::errstr
($connectTo)");
my $sth = $dbh->prepare("SELECT ?") or die $DBI::errstr;

for ($T=0; $T<10000; $T++) {
$sth->execute($T);
$sth->finish;
}
$dbh->disconnect();

The 'time' results:
- Running local:
real 0m2.770s
user 0m0.490s
sys 0m0.250s
- Via network:
real 0m39.919s
user 0m0.470s
sys 0m0.190s

Browse pgsql-admin by date

  From Date Subject
Next Message Joel Burton 2002-06-07 13:45:36 Re: What err ???
Previous Message nikolaus 2002-06-07 03:43:14 Re: performance issue using DBI