>>>>> On 08 Jul 2011 at 14:33 "m" == mithraen  writes:

m> On Fri, Jul 08, 2011 at 09:27:16AM +0600, Дмитрий Дегтярев wrote:
>> Пробовал ставить под postgres.. 
m> ext4 + data=journal (на отдельном диске или лучше SSD) the best.

Для postgres не надо journal.

Tip: Because WAL restores database file contents after a crash, journaled file
systems are not necessary for reliable storage of the data files or WAL
files. In fact, journaling overhead can reduce performance, especially if
journaling causes file system data to be flushed to disk. Fortunately, data
flushing during journaling can often be disabled with a file system mount
option, e.g. data=writeback on a Linux ext3 file system. Journaled file
systems do improve boot speed after a crash.

http://www.postgresql.org/docs/9.0/interactive/wal-intro.html

Лучше выключить write cache, если нету всяких BBU.
http://www.postgresql.org/docs/9.0/interactive/wal-reliability.html

-- 
vvk

_______________________________________________
Sysadmins mailing list
Sysadmins@lists.altlinux.org
https://lists.altlinux.org/mailman/listinfo/sysadmins

Ответить