Re: BufferAccessStrategy for bulk insert

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BufferAccessStrategy for bulk insert
Дата
Msg-id 27941.1225833539@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: BufferAccessStrategy for bulk insert  ("Robert Haas" <robertmhaas@gmail.com>)
Ответы Re: BufferAccessStrategy for bulk insert  ("Robert Haas" <robertmhaas@gmail.com>)
Список pgsql-hackers
"Robert Haas" <robertmhaas@gmail.com> writes:
>> 2. The logic changes in RelationGetBufferForTuple seem bizarre and
>> overcomplicated.  ISTM that the buffer saved by the bistate ought to
>> be about equivalent to relation->rd_targblock, ie, it's your first
>> trial location and also a place to save the located buffer on the way
>> out.  I'd suggest tossing that part of the patch and starting over.

> Hmm, would that be safe in the presence of concurrent or recursive
> bulk inserts into the same relation?

As safe as it is now --- you're relying on the bistate to carry the
query-local state.  Probably the best design is to just ignore
rd_targblock when a bistate is provided, and use the bistate's buffer
instead.
        regards, tom lane


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

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: ARRAY vars (was Enable pl/python to return records based on multiple OUT params)
Следующее
От: Kenneth Marshall
Дата:
Сообщение: Re: [PATCHES] updated hash functions for postgresql v1