Re: Bugs/slowness inserting and indexing cubes

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bugs/slowness inserting and indexing cubes
Дата
Msg-id 11015.1329260043@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bugs/slowness inserting and indexing cubes  (Alexander Korotkov <aekorotkov@gmail.com>)
Ответы Re: Bugs/slowness inserting and indexing cubes  (Alexander Korotkov <aekorotkov@gmail.com>)
Список pgsql-hackers
Alexander Korotkov <aekorotkov@gmail.com> writes:
> ITSM, I found the problem. This piece of code is triggering an error. It
> assumes each page of corresponding to have initialized buffer. That should
> be true because we're inserting index tuples from up to down while
> splits propagate from down to up.
> But this assumptions becomes false we turn buffer off in the root page. So,
> root page can produce pages without initialized buffers when splits.

Hmm ... can we tighten the error check rather than just remove it?  It
feels less than safe to assume that a hash-entry-not-found condition
*must* reflect a corner-case situation like that.  At the very least
I'd like to see it verify that we'd turned off buffering before deciding
this is OK.  Better, would it be practical to make dummy entries in the
hash table even after turning buffers off, so that the logic here
becomes
if (!found) error;else if (entry is dummy) return without doing anything;else proceed;
        regards, tom lane


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: When do we lose column names?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_test_fsync performance