Re: performance problem - 10.000 databases

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: performance problem - 10.000 databases
Дата
Msg-id 19628.1068131865@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: performance problem - 10.000 databases  (Marek Florianczyk <franki@tpi.pl>)
Список pgsql-admin
Marek Florianczyk <franki@tpi.pl> writes:
> W li�cie z czw, 06-11-2003, godz. 15:37, Jeff pisze:
>> I would *STRONGLY* advise not running with fsync=false in production as
>> PG _CANNOT_ guaruntee data consistancy in the event of a hardware
>> failure.  It would sure suck to have a power failure screw up your nice
>> db for the users!

> Sure I know, but with WAL it will make fsync every some? seconds, right?

No.  fsync = false turns off fsync of WAL.  It's okay for development
but not when you actually care about integrity of your data.

            regards, tom lane

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

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Re: Microsoft access verses postgresql
Следующее
От: "scott.marlowe"
Дата:
Сообщение: Re: performance problem - 10.000 databases