RE: Re: Loading optimization

Поиск
Список
Период
Сортировка
От Mikheev, Vadim
Тема RE: Re: Loading optimization
Дата
Msg-id 8F4C99C66D04D4118F580090272A7A234D3268@sectorbase1.sectorbase.com
обсуждение исходный текст
Ответ на Loading optimization  (Gary Wesley <gary@db.stanford.edu>)
Ответы Re: Re: Loading optimization
Список pgsql-general
> This is OK for table files, unless someone's broken the code that will
> auto-initialize a zero page when it comes across one.

Hmmm, I don't see anything like auto-initialization in code -:(
Where did you put these changes?

> I had a note to myself saying that zeroed pages in indexes may not be
> OK, but I'm not sure if that's really a risk or not.  btree, at least,
> never does any linear scans of an index file; it can only visit pages
> that are linked to by parent or sibling links.  If we are careful that
> we init a btree page before we modify its sibling(s) and parent, we
> should be OK.

Should be covered by WALoging of newroot & split ops which only add
new pages.

Vadim

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Select * from ( Select etc..)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: postmaster won't run