Re: autovacuum

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: autovacuum
Дата
Msg-id 87vea59ehw.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: autovacuum  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
"Scott Marlowe" <scott.marlowe@gmail.com> writes:

> RAID5 optimizes for space, not performance or reliability.  It gets
> faster but less reliable as it gets bigger.  If you can afford the
> space RAID-10 is generally preferred.

RAID5 can be faster for DSS style work loads. If you're writing data to the
raid in large contiguous chunks then it you get higher bandwidth than RAID1+0.

The problem with RAID5 is that if you're writing random access chunks then
it's even slower than not having a raid at all.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Adding domain type with CHECK constraints slow on large table
Следующее
От: "Merlin Moncure"
Дата:
Сообщение: Re: Migration from PervasiveSQL