Re: [GENERAL] 6.5 connection time: too slow (?)

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