Re: Slow application response on lightly loaded server?

Поиск
Список
Период
Сортировка
От Mike Blackwell
Тема Re: Slow application response on lightly loaded server?
Дата
Msg-id CANPAkguGHV21b2PA7mo4KqR7-Rzis=ESMW_fEXUDCm=RQMt0kw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Slow application response on lightly loaded server?  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Slow application response on lightly loaded server?  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-performance



On Tue, Jul 17, 2012 at 11:35 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:

I'd run vmstat and look for high cs or int numbers (100k and above) to
see if you're maybe seeing an issue with that.  A lot of times a
"slow" server is just too much process switching.  But yeah, the
graphs you've posted don't seem overly bad.


Thanks for the tip.  Here's a quick look at those numbers under that same load.  Watching it for a while longer didn't show any spikes.  That doesn't seem to be it, either.  

$ vmstat 5
procs -----------memory---------- ---swap-- -----io---- --system-- ----cpu----
 r  b   swpd   free   buff  cache   si   so    bi    bo   in    cs us sy id wa
 3  0  11868  34500  16048 3931436    0    0     4     2    0     0  6  2 91  1
 2  0  11868  21964  16088 3931396    0    0     0   212 8667  8408 15  3 80  2
 0  0  11868  37772  16112 3932152    0    0     2   249 9109  8811 34  2 62  1
 2  0  11868  34068  16124 3932400    0    0     1   168 9142  9165 12  3 84  1
 1  0  11868  38036  16124 3932920    0    0     8   155 9995 10904 16  4 80  1
 1  0  11868  40212  16124 3933440    0    0     0   146 9586  9825 13  3 83  1

__________________________________________________________________________________
Mike Blackwell | Technical Analyst, Distribution Services/Rollout Management | RR Donnelley
1750 Wallace Ave | St Charles, IL 60174-3401
Office: 630.313.7818
Mike.Blackwell@rrd.com
http://www.rrdonnelley.com



В списке pgsql-performance по дате отправления:

Предыдущее
От: Claudio Freire
Дата:
Сообщение: Re: very very slow inserts into very large table
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Slow application response on lightly loaded server?