Re: limiting performance impact of wal archiving.

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: limiting performance impact of wal archiving.
Дата
Msg-id dcc563d10911100743j640c471cn78b5394dca2b5120@mail.gmail.com
обсуждение исходный текст
Ответ на Re: limiting performance impact of wal archiving.  (Laurent Laborde <kerdezixe@gmail.com>)
Список pgsql-performance
On Tue, Nov 10, 2009 at 8:00 AM, Laurent Laborde <kerdezixe@gmail.com> wrote:
>
> Desktop drive can easily do 60MB/s in *sequential* read/write.
> We use high performance array of 15.000rpm SAS disk on an octocore
> 32GB and IO is always a problem.

How man drives in the array?  Controller? RAID level?

> I explain the problem :
>
> This server (doing wal archiving) is the master node of the
> over-blog's server farm.
> hundreds of GB of data, tens of millions of articles and comments,
> millions of user, ...
> ~250 read/write sql requests per seconds for the master
> ~500 read sql request per slave.

That's really not very fast.

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

Предыдущее
От: Laurent Laborde
Дата:
Сообщение: Re: limiting performance impact of wal archiving.
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: limiting performance impact of wal archiving.