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