From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> |
Cc: | The Hermit Hacker <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgreSQL(dot)org |
Subject: | Re: [HACKERS] All things equal, we are still alot slower then MySQL? |
Date: | 1999-09-19 16:03:00 |
Message-ID: | 27446.937756980@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu> writes:
>> Using the exact same data, and the exact same queries (dbi is cool):
>> 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
>>>> From the 'time' numbers, MySQL is running ~17sec faster, but uses up 23%
>> more CPU to do this...so where is our slowdown?
> I don't remember if you gave details on the sizes of tables, but in
> any case I'm going to guess that you are spending almost all of your
> time in the optimizer.
No --- if he were, it'd be all CPU time, not 2.7% CPU usage. The time's
got to be going into disk accesses. I'm perfectly prepared to blame
the optimizer, but I think it's because of a bad plan not too much time
spent making the plan...
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 1999-09-19 16:26:18 | Re: INSERT/DEFAULT VALUES broken? |
Previous Message | Tom Lane | 1999-09-19 15:59:10 | Re: INSERT/DEFAULT VALUES broken? |