Re: Seeking performance advice and explanation for high I/O on 8.3

From: "Scott Otis" <scott(dot)otis(at)intand(dot)com>
To: "Ivan Voras" <ivoras(at)freebsd(dot)org>
Cc: <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Seeking performance advice and explanation for high I/O on 8.3
Date: 2009-09-03 22:51:03
Message-ID: F406B740738CB44A8BCBEF9734ECF663683F4C@albus.intand.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> Simply do "iostat mfid0 1" and post 10 lines of its output.

tty mfid0 cpu
tin tout KB/t tps MB/s us ni sy in id
0 152 108.54 335 35.51 43 0 30 1 27
0 525 85.73 759 63.55 14 0 12 0 74
0 86 67.72 520 34.39 13 0 12 0 75
0 86 86.89 746 63.26 12 0 12 0 76
0 86 70.09 594 40.65 13 0 11 0 76
0 86 78.50 756 57.99 13 0 10 0 77
0 351 81.46 774 61.61 12 0 11 0 77
0 86 63.87 621 38.72 9 0 8 0 83
0 86 80.87 821 64.86 8 0 8 0 83
0 86 58.78 637 36.55 11 0 11 0 77

Scott

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Otis 2009-09-03 23:11:13 Re: Seeking performance advice and explanation for high I/O on 8.3
Previous Message Kevin Grittner 2009-09-03 22:03:45 Re: PostgreSQL not using index for statement with group by