Re: WAL/pg_xlog on Another Disk: Redundancy?

Поиск
Список
Период
Сортировка
От Mike Rylander
Тема Re: WAL/pg_xlog on Another Disk: Redundancy?
Дата
Msg-id b918cf3d041215175264092591@mail.gmail.com
обсуждение исходный текст
Ответ на WAL/pg_xlog on Another Disk: Redundancy?  (Thomas F.O'Connell <tfo@sitening.com>)
Список pgsql-general
On Tue, 14 Dec 2004 15:38:45 -0600, Thomas F.O'Connell <tfo@sitening.com> wrote:

[snip]

> Would a more ideal setup be a six-drive server with a RAID 1+0 on four
> drives with 2 drives dedicated to WAL that mirrored one another? Is
> that overkill? Anyone have recommendations for an appropriate setup for
> a 5-bay server?

A six drive setup would be great.  You definitly want some protection
for the WAL data.  I've seen up to a 20% increase on write-heavy
servers after moving pg_xlog to it's own disk.

>
> Thanks!
>
> -tfo
>
> --
> Thomas F. O'Connell
> Co-Founder, Information Architect
> Sitening, LLC
> http://www.sitening.com/
> 110 30th Avenue North, Suite 6
> Nashville, TN 37203-6320
> 615-260-0005
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>


--
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org

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

Предыдущее
От: Paul Tillotson
Дата:
Сообщение: Re: Performance suggestions?
Следующее
От: Simon Wittber
Дата:
Сообщение: Debian Packages for Postgresql 8.0.0 RC1