Re: insert performance for win32 - Mailing list pgsql-performance

From Qingqing Zhou
Subject Re: insert performance for win32
Date
Msg-id dkg9bt$fjj$1@news.hub.org
Whole thread Raw
In response to Re: insert performance for win32  ("Merlin Moncure" <merlin.moncure@rcsonline.com>)
List pgsql-performance
""Merlin Moncure"" <merlin.moncure@rcsonline.com> wrote
> ok, here is gprof output from newlines/no newlines
> [newlines]
>  %   cumulative   self              self     total
> time   seconds   seconds    calls   s/call   s/call  name
> 19.03      0.67     0.67        1     0.67     3.20  MainLoop
> 17.61      1.29     0.62   500031     0.00     0.00  yylex
> 15.63      1.84     0.55  1500094     0.00     0.00  GetVariable
> 11.08      2.23     0.39   250018     0.00     0.00  SendQuery
>  4.26      2.38     0.15   750051     0.00     0.00  GetVariableBool
>  3.41      2.50     0.12   250024     0.00     0.00  SetVariable
>  2.56      2.59     0.09   250015     0.00     0.00  gets_fromFile
>  2.27      2.67     0.08   750044     0.00     0.00
> yy_switch_to_buffer
>  2.27      2.75     0.08   500031     0.00     0.00  psql_scan
>  2.27      2.83     0.08                             pg_strcasecmp
>  1.70      2.89     0.06  4250078     0.00     0.00  emit
>  1.70      2.95     0.06   500031     0.00     0.00  VariableEquals
>  1.70      3.01     0.06   250018     0.00     0.00  AcceptResult
>  1.42      3.06     0.05   250018     0.00     0.00  ResetCancelConn
>

Maybe I missed some threads .... do you think it is interesting to test the
*absoulte* time difference of the same machine on Windows/Linux by using
timeit.c? I wonder if windows is slower than Linux ...

Regards,
Qingqing



pgsql-performance by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] insert performance for win32
Next
From: "Magnus Hagander"
Date:
Subject: Re: [HACKERS] insert performance for win32