Re: What exactly is postgres doing during INSERT/UPDATE ?

Поиск
Список
Период
Сортировка
От Pierre Frédéric Caillaud
Тема Re: What exactly is postgres doing during INSERT/UPDATE ?
Дата
Msg-id op.uzc35vvbcke6l8@soyouz
обсуждение исходный текст
Ответ на What exactly is postgres doing during INSERT/UPDATE ?  (Joseph S <jks@selectacast.net>)
Список pgsql-performance
> top shows the cpu usage of the pg process ranges from zero to never more
> than ten percent of a cpu, and that one cpu is always ninety some odd
> percent in iowait.  So what is postgres doing (with fsync off) that
> causes the cpu to spend so much time in iowait?

    Updating indexes ?

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

Предыдущее
От: Joseph S
Дата:
Сообщение: What exactly is postgres doing during INSERT/UPDATE ?
Следующее
От: Greg Smith
Дата:
Сообщение: Re: What exactly is postgres doing during INSERT/UPDATE ?