Re: Would it be OK if I put db file on a ext2 filesystem?

Поиск
Список
Период
Сортировка
От Collin Kidder
Тема Re: Would it be OK if I put db file on a ext2 filesystem?
Дата
Msg-id 4760026A.3070900@kkmfg.com
обсуждение исходный текст
Ответ на Would it be OK if I put db file on a ext2 filesystem?  (Magicloud Wang <magicloud@pogolinux.com.cn>)
Ответы Re: Would it be OK if I put db file on a ext2 filesystem?  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список pgsql-general
Magicloud Wang wrote:
> Dear,
>     I think database has its own operation journal, and different journal
> filesystem does give different performance. So if I put database file on a
> non-journal filesystem, would it be safe? Does this like using a raw device?
>
>
>
You lose a little bit of data integrity in exchange for a little bit of
speed. I suppose it'd be a fine thing to do so long as you can live with
that trade off. If you want good data integrity you are more likely to
get it from battery backed RAID5 or RAID10 or something of that sort
rather than just trusting something like EXT3 or Reiser. EXT2 isn't a
bad file system.

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: How can I insert NULL into column with the type of timestamp?
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Better alternative for Primary Key then serial??