Hi, On Tue, Feb 23, 2010 at 12:51 AM, Yang Zhang <yanghatespam@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
