AW: WAL-based allocation of XIDs is insecure
От | Zeugswetter Andreas SB |
---|---|
Тема | AW: WAL-based allocation of XIDs is insecure |
Дата | |
Msg-id | 11C1E6749A55D411A9670001FA687963368230@sdexcsrv1.f000.d0188.sd.spardat.at обсуждение исходный текст |
Список | pgsql-hackers |
> > > Hm, wasn't it handling non-atomic disk writes, Andreas? > > > > Yes, but for me, that was only one (for me rather minor) issue. > > I still think that the layout of PostgreSQL pages was designed to > > reduce the risc of a (heap) page beeing inconsistent because it is > > only partly written to an acceptable minimum. If your hw and os can > > I believe that I explained why it's not minor issue (and never was). > Eg - PageRepaireFragmentation "compacts" page exactly like other, But this is currently only done during vacuum and as such a special case, no ? > overwriting, DBMSes do and partial write of modified page means > lost page content. Yes, if contents move around. Not with the original Postgres 4 heap page design in combination with non overwrite smgr. Maybe this has changed because someone oversaw the consequences ? This certainly changes when converting to overwrite smgr, because then you reuse a slot that might not be the correct size and contents need to be shifted around. For this case your "physical log" is also good, of course :-) Andreas
В списке pgsql-hackers по дате отправления: