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
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 |