Re: New server: SSD/RAID recommendations?

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: New server: SSD/RAID recommendations?
Дата
Msg-id 559C30F2.3000703@iki.fi
обсуждение исходный текст
Ответ на Re: New server: SSD/RAID recommendations?  ("Graeme B. Bell" <graeme.bell@nibio.no>)
Список pgsql-performance
On 07/07/2015 10:59 PM, Graeme B. Bell wrote:
> Cache flushing isn't an atomic operation though. Even if the ordering
> is right, you are likely to have a partial fsync on the disk when the
> lights go out - isn't your FS still corrupt?

If the filesystem is worth its salt, no. Journaling filesystems for
example rely on the journal to work around that problem, and there are
other mechanisms.

PostgreSQL has exactly the same problem and uses the WAL to solve it.

- Heikki



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

Предыдущее
От: "Graeme B. Bell"
Дата:
Сообщение: Re: New server: SSD/RAID recommendations?
Следующее
От: "Graeme B. Bell"
Дата:
Сообщение: Re: Hmmm... why does pl/pgsql code parallelise so badly when queries parallelise fine? Anyone else seen this?