Re: Postgresql Performance on an HP DL385 and

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Postgresql Performance on an HP DL385 and
Дата
Msg-id 19783.1155672317@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Postgresql Performance on an HP DL385 and  (mark@mark.mielke.cc)
Ответы Re: Postgresql Performance on an HP DL385 and  (mark@mark.mielke.cc)
Список pgsql-performance
mark@mark.mielke.cc writes:
> I've been worrying about this myself, and my current conclusion is that
> ext2 is bad because: a) fsck, and b) data can be lost or corrupted, which
> could lead to the need to trash the xlog.

> Even ext3 in writeback mode allows for the indirect blocks to be updated
> without the data underneath, allowing for blocks to point to random data,
> or worse, previous apparently sane data (especially if the data is from
> a drive only used for xlog - the chance is high that a block might look
> partially valid?).

At least for xlog, this worrying is misguided, because we zero and fsync
a WAL file before we ever put any valuable data into it.  Unless the
filesystem is lying through its teeth about having done an fsync, there
should be no metadata changes happening for an active WAL file (other
than mtime of course).

            regards, tom lane

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

Предыдущее
От: mark@mark.mielke.cc
Дата:
Сообщение: Re: Postgresql Performance on an HP DL385 and
Следующее
От: "Bucky Jordan"
Дата:
Сообщение: Re: Dell PowerEdge 2950 performance