Re: [ADMIN] Postgres network preformance

2002-06-07 Thread nikolaus
Ferdinand, The results are not bad at all. But your test seems flawed to me. And you would get the same result regardles of database engine used. You do 10,000 loops and each loop has 2 calls to the DBI module. So if your network roundtrip is really exactly 1ms that would put you at 20,000ms

[ADMIN] Postgres network preformance

2002-06-07 Thread 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=obe