Re: 500 tpsQL + WAL log implementation

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: 500 tpsQL + WAL log implementation
Дата
Msg-id Pine.LNX.4.33.0211121013480.24725-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: 500 tpsQL + WAL log implementation  ("Curtis Faith" <curtis@galtair.com>)
Список pgsql-hackers
Curtis, have you considered comparing raw writes versus file system writes 
on a raw multi-disk partition?

I always set up my machines to store data on a mirror set (RAID1) or RAID5 
set, and it seems your method should be tested there too.

P.s., Tom, the postgresql user would NOT need to run as root to do this, 
you can just do a 'chown postgres.postgres /dev/sda1' or 'chown 
postgres.postgres /dev/md0' to give postgresql permission to write / read 
from a raw partition.

That said, I am not sure how much we are likely to gain from this method 
either.  But if no one tries it out we'll never know.



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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: RE : Stability problems
Следующее
От: Tom Lane
Дата:
Сообщение: Re: RC1?