Bruce Momjian wrote:
> Very strange. Same postmaster flags? I can't imagine what it would be?
> We really have been improving performance, including startup
> performance.
The only difference I see is -i flag on the 6.5 postmaster, but removing it
doesn't change a thing, connecting is consistently 0.2934-0.2939 sec (only
other flag both server use is -S). To explain, I'm running simple test script
starting
use DBI;
use Data::Dumper;
use Time::HiRes qw/gettimeofday tv_interval/;
$start = [gettimeofday];
$db = DBI->connect("DBI:Pg:dbname=rfp") or die $DBI::errstr;
print "connect: ", tv_interval($start, [gettimeofday]), "\n";
Maybe both servers were compiled with different options, but I don't
know how to check with which ones. Any simple way how to find ou?
BTW, the exact results were
P2/233,PG6.5.2
connect 0.295
prepare 0.001
execute (select * from table)
60 rows/10 cols 0.153
15000 rows/4 cols 1.345
15000 rows/4 cols/LIMIT 30 0.044
15000 rows/4 cols/LIMIT 30 OFFSET 2000 0.050
fetch 30 0.002
finnish 0.000
disconnect 0.002
K6/166,pg6.4
connect 0.105
prepare 0.001
execute (select * from table)
60 rows/10 cols 0.162
15000 rows/4 cols 3.508 (finnish 0.091)
fetch 30 0.008
finnish 0.002
disconnect 0.001
It shows up to LIMIT/OFFSET brings 30fold speed up as expected (main reason
for upgrading, after all) and also that the same (bigger) select takes 1.345
vs. 3.508 sec
which corresponds reasonably well to the slower machine and older postgres.
Only
the connection time is a mystery.
- Robert
