Re: ProstGreSQL on RAID Question

Поиск
Список
Период
Сортировка
От Curt Sampson
Тема Re: ProstGreSQL on RAID Question
Дата
Msg-id Pine.NEB.4.44.0208121228540.2317-100000@angelic.cynic.net
обсуждение исходный текст
Ответ на ProstGreSQL on RAID Question  (Chris Ruprecht <chrup@earthlink.net>)
Ответы Re: ProstGreSQL on RAID Question  (Chris Ruprecht <chrup@earthlink.net>)
Список pgsql-admin
On Mon, 12 Aug 2002, Chris Ruprecht wrote:

> I have set up a RAID-5 (soft RAID) arrray on my Linux machine,
> consisting of 5 18 GB UltraSCSI-2 (80 MB/sec) drives. Everythinng is
> working but I would like to know, where I can tweak this for optimum
> performance.

If you do a lot of inserts, move the log file ($PGDATA/pg_xlog)
off the RAID-5 and on to a separate RAID-1 (mirrored) pair. This will
separate the buffered random writes to the data files and the unbuffered,
sequential writes to the log.

cjs
--
Curt Sampson  <cjs@cynic.net>   +81 90 7737 2974   http://www.netbsd.org
    Don't you know, in this new Dark Age, we're all light.  --XTC


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

Предыдущее
От: Chris Ruprecht
Дата:
Сообщение: ProstGreSQL on RAID Question
Следующее
От: Chris Mungall
Дата:
Сообщение: Re: abnormally long time in performing a two-table join