Re: Dead code with short varlenas in toast_save_datum()

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Dead code with short varlenas in toast_save_datum()
Дата
Msg-id aJKwTiTnB7XLxxZP@paquier.xyz
обсуждение исходный текст
Ответ на Re: Dead code with short varlenas in toast_save_datum()  (Nikhil Kumar Veldanda <veldanda.nikhilkumar17@gmail.com>)
Ответы Re: Dead code with short varlenas in toast_save_datum()
Список pgsql-hackers
On Tue, Aug 05, 2025 at 10:26:03AM -0700, Nikhil Kumar Veldanda wrote:
> This code path is currently not covered by tests. It can be exercised
> with the following SQL pattern
>
> CREATE TABLE temp_tbl (a text, b text);
> ALTER TABLE temp_tbl SET (toast_tuple_target = 128);
> ALTER TABLE temp_tbl ALTER COLUMN a SET STORAGE EXTERNAL;
> ALTER TABLE temp_tbl ALTER COLUMN b SET STORAGE EXTERNAL;
> INSERT INTO temp_tbl values(repeat('a', 4000), repeat('a', 120));

Ah, thanks, nice one.  I did not consider the trick of using two
attributes to bypass the check when externalizing the tuple.  I'll go
add a test in strings.sql among these lines, with some TOAST slice
scans based on substr().
--
Michael

Вложения

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