Re: pgsql-server: Add: > > * Allow buffered WAL writes

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: pgsql-server: Add: > > * Allow buffered WAL writes
Дата
Msg-id 200408140323.i7E3Nef23930@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: pgsql-server: Add: > > * Allow buffered WAL writes and fsync > >  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: pgsql-server: Add: > > * Allow buffered WAL writes  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-committers
Tom Lane wrote:
> momjian@svr1.postgresql.org (Bruce Momjian) writes:
> > Add:
> >> * Allow buffered WAL writes and fsync
> >>
> >> Instead of guaranteeing recovery of all committed transactions, this
> >> would provide improved performance by delaying WAL writes and fsync
> >> so an abrupt operating system restart might lose a few seconds of
> >> committed transactions but still be consistent.
>
> Who exactly signed onto this as a good idea?  It sure doesn't square
> with my ideas of an ACID database.  Committed means committed, not
> "maybe if you're lucky committed".

True but we support fsync.  Certainly it would be more useful than
fsync, and it might allow us to remove fsync.

No one has to sign TODO items, BTW.  They are added and removed as
requested.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pgsql-server: Add: > > * Allow buffered WAL writes and fsync > >
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pgsql-server: Add: > > * Allow buffered WAL writes