Re: [HACKERS] All things equal, we are still alot slower then MySQL? - Mailing list pgsql-hackers

From Thomas Lockhart
Subject Re: [HACKERS] All things equal, we are still alot slower then MySQL?
Date
Msg-id 37E5A446.6D69755A@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] All things equal, we are still alot slower then MySQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> >>> MySQL: 0.498u 0.150s 0:02.50 25.6%     10+1652k 0+0io 0pf+0w
> >>> PgSQL: 0.494u 0.061s 0:19.78 2.7%      10+1532k 0+0io 0pf+0w
> > No --- if he were, it'd be all CPU time, not 2.7% CPU usage.
> Er, wait a second.  Are we measuring backend-process runtime here,
> or is that the result of 'time' applied to a *client* ?

Right. That was my point; unless he is firing up the backend using
"time", or running it standalone, it is hard to measure real CPU
time...
                 - Thomas

-- 
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California


pgsql-hackers by date:

Previous
From: "Hiroshi Inoue"
Date:
Subject: RE: [HACKERS] couldn't rollback cache ?
Next
From: Thomas Lockhart
Date:
Subject: Re: INSERT/DEFAULT VALUES broken?