Re: Insert only tables and vacuum performance

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Insert only tables and vacuum performance
Дата
Msg-id 9781.1083380676@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Insert only tables and vacuum performance  (Joseph Shraibman <jks@selectacast.net>)
Список pgsql-performance
Joseph Shraibman <jks@selectacast.net> writes:
> INFO:  "elog": found 0 removable, 12869411 nonremovable row versions in
> 196195 pages
> DETAIL:  0 dead row versions cannot be removed yet.
> There were 5 unused item pointers.
> 0 pages are entirely empty.
> CPU 31.61s/4.53u sec elapsed 1096.83 sec.

Hmm.  These numbers suggest that your disk subsystem's bandwidth is
only about 1.4 Mbytes/sec.  Was there a lot else going on?

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: planner/optimizer question
Следующее
От: Robert Creager
Дата:
Сообщение: Re: Wierd context-switching issue on Xeon