Questions about fsync

Поиск
Список
Период
Сортировка
От Fabio C. Bon
Тема Questions about fsync
Дата
Msg-id 025b01c5945a$dfc1ba70$0501a8c0@fabio
обсуждение исходный текст
Список pgsql-admin
In the context of PostgreSQL 7.4, running over Linux Suse 9.0, I have some
doubts that wanted to evacuate:

In which processes impacts the property fsync?

Which can be the problem to use fsync in false?

When use fsync = false, the effective recording of the data in disk is done
for criteria of the operating system, ¿ Is exact?

Considering fsync = false, checkpoint_timeout=300.
It given a crash of the operating system, after normally db shutdown.  At db
startup, there was corruption of data and a pg_resetlogwas done.

It is possible to lose data changed previous to last checkpoint ?

Thanks,
Fabio


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

Предыдущее
От: "sandeep kotecha"
Дата:
Сообщение: Postgres and Tomcat combined installation on Windows
Следующее
От: Chris Travers
Дата:
Сообщение: Re: Question on placing database on a network attached storage