Re: understanding postgres issues/bottlenecks

Поиск
Список
Период
Сортировка
От Stefano Nichele
Тема Re: understanding postgres issues/bottlenecks
Дата
Msg-id bdb13b210901071302t1ef71ad0wb17408e7cca00a2d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: understanding postgres issues/bottlenecks  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы Re: understanding postgres issues/bottlenecks  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-performance

On Tue, Jan 6, 2009 at 7:45 PM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
I concur with Merlin you're I/O bound.

Adding to his post, what RAID controller are you running, does it have
cache, does the cache have battery backup, is the cache set to write
back or write through?
 
At the moment I don't have such information. It's a "standard" RAID controller coming with a DELL server. Is there any information I can have asking to the SO ?



Also, what do you get for this (need contrib module pgbench installed)

pgbench -i -s 100
pgbench -c 50 -n 10000

? Specifically transactions per second?

I'll run pgbench in the next days.

Cheers,
ste

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

Предыдущее
От: Stefano Nichele
Дата:
Сообщение: Re: understanding postgres issues/bottlenecks
Следующее
От: "Scott Marlowe"
Дата:
Сообщение: Re: understanding postgres issues/bottlenecks