pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Qingqing Zhou <zhouqq@cs.toronto.edu>
To: pgsql-performance@postgresql.org
Subject: Re: insert performance for win32
Date: Fri, 4 Nov 2005 13:30:34 -0500
Message-ID: <dkg9bt$fjj$1@news.hub.org> (raw)
References: <6EE64EF3AB31D5448D0007DD34EEB3417DD7CE@Herge.rcsinc.local>


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

view thread (53+ messages)  latest in thread

Message-ID: <dkg9bt$fjj$1@news.hub.org>
Permalink:  ../dkg9bt$fjj$1@news.hub.org/
Also on:    postgresql.org/message-id/dkg9bt$fjj$1@news.hub.org

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: zhouqq@cs.toronto.edu
  Subject: Re: insert performance for win32
  In-Reply-To: <dkg9bt$fjj$1@news.hub.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox