Re: Large expressions in indexes can't be stored (non-TOASTable)

Поиск
Список
Период
Сортировка
От Nathan Bossart
Тема Re: Large expressions in indexes can't be stored (non-TOASTable)
Дата
Msg-id aA_zMYasoUwNrDx1@nathan
обсуждение исходный текст
Ответ на Re: Large expressions in indexes can't be stored (non-TOASTable)  (Nathan Bossart <nathandbossart@gmail.com>)
Ответы Re: Large expressions in indexes can't be stored (non-TOASTable)
Список pgsql-hackers
On Wed, Apr 23, 2025 at 04:44:51PM -0500, Nathan Bossart wrote:
> On Wed, Apr 23, 2025 at 05:33:41PM -0400, Tom Lane wrote:
>> I don't see any comments in this patch that capture the real
>> reason for removing pg_replication_origin's TOAST table,
>> namely (IIUC) that we'd like to be able to access that catalog
>> without a snapshot.  I think it's important to record that
>> knowledge, because otherwise somebody is likely to think they
>> can undo this change for $whatever-reason.
> 
> D'oh, yes, I'd better add that.

I updated the comment atop the check in the misc_sanity test for system
tables with varlena columns but no toast table.  If you were to reintroduce
pg_replication_origin's toast table, you'd have to at least fix the
expected output for this test, so the comment theoretically has a higher
chance of being seen.

-- 
nathan

Вложения

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