Re: Extending SMgrRelation lifetimes

Поиск
Список
Период
Сортировка
От Heikki Linnakangas
Тема Re: Extending SMgrRelation lifetimes
Дата
Msg-id 8d0f8c76-fb2e-4e8b-a653-df0459c50b21@iki.fi
обсуждение исходный текст
Ответ на Re: Extending SMgrRelation lifetimes  (Heikki Linnakangas <hlinnaka@iki.fi>)
Список pgsql-hackers
On 29/11/2023 14:41, Heikki Linnakangas wrote:
> 2. A funny case with foreign tables: ANALYZE on a foreign table calls
> visibilitymap_count(). A foreign table has no visibility map so it
> returns 0, but before doing so it calls RelationGetSmgr on the foreign
> table, which has 0/0/0 rellocator. That creates an SMgrRelation for
> 0/0/0, and sets the foreign table's relcache entry as its owner. If you
> then call ANALYZE on another foreign table, it also calls
> RelationGetSmgr with 0/0/0 rellocator, returning the same SMgrRelation
> entry, and changes its owner to the new relcache entry. That doesn't
> make much sense and it's pretty accidental that it works at all, so
> attached is a patch to avoid calling visibilitymap_count() on foreign
> tables.

This patch seems uncontroversial and independent of the others, so I 
committed it.

-- 
Heikki Linnakangas
Neon (https://neon.tech)




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

Предыдущее
От: Alexander Pyhalov
Дата:
Сообщение: Re: Assert failure on 'list_member_ptr(rel->joininfo, restrictinfo)'
Следующее
От: David Rowley
Дата:
Сообщение: Re: Memory consumed by paths during partitionwise join planning