| From: | Baron Schwartz <baron(at)xaprb(dot)com> |
|---|---|
| To: | Yang Zhang <yanghatespam(at)gmail(dot)com> |
| Cc: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Sorting performance vs. MySQL |
| Date: | 2010-02-24 04:08:22 |
| Message-ID: | 4cfa0b031002232008q3dff3354paabede9ece442774@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
On Tue, Feb 23, 2010 at 12:51 AM, Yang Zhang <yanghatespam(at)gmail(dot)com> wrote:
> When running the query in MySQL InnoDB:
>
> $ vmstat 10
> procs -----------memory---------- ---swap-- -----io---- --system--
> -----cpu------
> r b swpd free buff cache si so bi bo in cs us sy id wa st
> 0 13 13733604 83020 5648 2193884 3 3 936 168 2 1
> 4 2 89 5 0
> 1 12 13749952 80164 5600 2178032 0 4354 908 4379 3586 2638
> 0 1 38 60 0
> 0 19 13762228 80576 5556 2145220 208 3527 1280 3690 3668 2635
> 1 1 39 59 0
> 0 19 13778632 79420 5560 2135228 52 4186 1046 4191 3682 2418
> 0 1 37 62 0
[snip]
> I'm guessing the swap numbers are because MySQL uses mmap?
InnoDB doesn't use mmap.
Baron
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thillai Selvan | 2010-02-24 04:43:41 | Re: [GENERAL] how do I do dump and restore without bugging with constraint? |
| Previous Message | Joe Conway | 2010-02-24 02:18:59 | Re: select t.name from tbl t (where "name" is not a column name) |