PostgreSQL vulnerabilities with fsync turned off?

Поиск
Список
Период
Сортировка
От nj7e@yahoo.com (John Moore)
Тема PostgreSQL vulnerabilities with fsync turned off?
Дата
Msg-id f91dbbdd.0106051548.62a683c8@posting.google.com
обсуждение исходный текст
Список pgsql-general
If one runs Postgresql with fsync turned off in order to get better
performance, is there a risk that the database internals will be
damaged by a system crash? I realize that database discrepancies are
possible, but I am referring to a failure where storage allocation
gets messed up, or critical internal pointers get mangled, or
something like that.

What I have been able to find so far only addresses data
discrepancies, which are something that we can live with (IF WE REALLY
HAVE TO).

Also, if one uses raw disk instead of files, will Postgresql work
better with or without fsync?

For that matter, how does Postgresql with fsync turned on compare
performance/wise to Informix/Oracle for typical OLTP (95% read 5%
write) work?

Thanks in advance

John Moore

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

Предыдущее
От: Grant
Дата:
Сообщение: Re: very big problem with NULL
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: total newbie question