Re: Checkpoint_segments optimal value

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Checkpoint_segments optimal value
Дата
Msg-id 53D30CEA.5080101@hogranch.com
обсуждение исходный текст
Ответ на Re: Checkpoint_segments optimal value  (Prabhjot Sheena <prabhjot.sheena@rivalwatch.com>)
Список pgsql-general
On 7/25/2014 5:58 PM, Prabhjot Sheena wrote:
> We do have i/o problem during heavy loads because we share mount point
> from netapp across different machines which we are getting rid in few
> weeks by moving stuff to Amazon aws and than IO issues will go away
> with fast iops

Netapp has to be some of the most expensive storage I've ever seen in a
datacenter and is frequently a source of performance problems.   NFS
isn't really appropriate for storing database data on, there's way too
many opportunites for fsync to get lost, more so if you've got a
virtualization layer in there too.





--
john r pierce                                      37N 122W
somewhere on the middle of the left coast



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

Предыдущее
От: Prabhjot Sheena
Дата:
Сообщение: Re: Checkpoint_segments optimal value
Следующее
От: Ramesh T
Дата:
Сообщение: Re: tab_to_sting