Re: COMMIT NOWAIT Performance Option

Поиск
Список
Период
Сортировка
От Jeff Davis
Тема Re: COMMIT NOWAIT Performance Option
Дата
Msg-id 1172627208.10824.428.camel@dogma.v10.wvs
обсуждение исходный текст
Ответ на Re: COMMIT NOWAIT Performance Option  (Josh Berkus <josh@agliodbs.com>)
Ответы Re: COMMIT NOWAIT Performance Option  (Josh Berkus <josh@agliodbs.com>)
Re: COMMIT NOWAIT Performance Option  ("Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>)
Список pgsql-hackers
On Tue, 2007-02-27 at 17:40 -0800, Josh Berkus wrote:
> All,
> 
> > > But we do don't we? fsync = off, full_page_writes = off?
> 
> BTW, our testing seems to indicate that full_page_writes = off is safe on 
> Solaris 10 on good hardware.  At least, we haven't been able to break it yet. 
> 

Is that an OS-dependent parameter? I always assumed it depended entirely
on hardware. I have no way to test it for myself though, so I just leave
full_page_writes=on to be safe. 

Regards,Jeff Davis



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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: COMMIT NOWAIT Performance Option
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: COMMIT NOWAIT Performance Option