Re: can't handle large number of INSERT/UPDATEs

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: can't handle large number of INSERT/UPDATEs
Дата
Msg-id 14215.1098830252@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: can't handle large number of INSERT/UPDATEs  ("Anjan Dave" <adave@vantage.com>)
Ответы Re: can't handle large number of INSERT/UPDATEs  (Curtis Zinzilieta <curtisz@norchemlab.com>)
Список pgsql-performance
"Anjan Dave" <adave@vantage.com> writes:
> One thing I am not sure is why 'bi' (disk writes) stays at 0 mostly,
> it's the 'bo' column that shows high numbers (reads from disk). With so
> many INSERT/UPDATEs, I would expect it the other way around...

Er ... it *is* the other way around.  bi is blocks in (to the CPU),
bo is blocks out (from the CPU).

            regards, tom lane

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

Предыдущее
От: John Meinel
Дата:
Сообщение: Re: Sequential Scan with LIMIT
Следующее
От: "Anjan Dave"
Дата:
Сообщение: Re: can't handle large number of INSERT/UPDATEs