[ADMIN] Postgres network preformance

[Ferdinand Smit]

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


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])