Re: Inserting 8MB bytea: just 25% of disk perf used?

Поиск
Список
Период
Сортировка
От Matthew Wakeling
Тема Re: Inserting 8MB bytea: just 25% of disk perf used?
Дата
Msg-id alpine.DEB.2.00.1001151123320.6195@aragorn.flymine.org
обсуждение исходный текст
Ответ на Re: Inserting 8MB bytea: just 25% of disk perf used?  ("fkater@googlemail.com" <fkater@googlemail.com>)
Ответы Re: Inserting 8MB bytea: just 25% of disk perf used?  ("fkater@googlemail.com" <fkater@googlemail.com>)
Список pgsql-performance
On Thu, 14 Jan 2010, fkater@googlemail.com wrote:
> Nevertheless: If your explanation covers all what can be
> said about it then replacing the hard disk by a faster one
> should increase the performance here (I'll try to check that
> out).

Probably. However, it is worth you running the test again, and looking at
how busy the CPU on the machine is. The disc may be the bottleneck, or the
CPU may be the bottleneck.

Matthew

--
"Take care that thou useth the proper method when thou taketh the measure of
 high-voltage circuits so that thou doth not incinerate both thee and the
 meter; for verily, though thou has no account number and can be easily
 replaced, the meter doth have one, and as a consequence, bringeth much woe
 upon the Supply Department."   -- The Ten Commandments of Electronics

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

Предыдущее
От: Matthew Wakeling
Дата:
Сообщение: Re: new server I/O setup
Следующее
От: Ivan Voras
Дата:
Сообщение: Re: New server to improve performance on our large and busy DB - advice? (v2)