Re: Large Databases redux

Поиск
Список
Период
Сортировка
От John R Pierce
Тема Re: Large Databases redux
Дата
Msg-id 4F6A4F13.3040206@hogranch.com
обсуждение исходный текст
Ответ на Large Databases redux  (Jason Herr <jaherr@gmail.com>)
Ответы Re: Large Databases redux  (Martijn van Oosterhout <kleptog@svana.org>)
Список pgsql-general
On 03/21/12 2:18 PM, Jason Herr wrote:
> I have my own theories based on what I've read and my puttering.  I
> think I can get away with a disk for the OS, disk for the WAL, disk
> for the large table (tablespaces) and a disk for the rest.  And when I
> say disk I mean storage device.  I'm thinking RAID1 15k disks for each
> set but the databases and then raid 10 or VERY large disks.

I think you're better off just making one big raid10 out of all the
disks and putting everything on it, maybe in different file systems to
seperate out file fragmentation.   this way the IO workload is evenly
distributed across all the disks.



--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


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

Предыдущее
От: Jeff Davis
Дата:
Сообщение: Re: pg_upgrade + streaming replication ?
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Large Databases redux