Re: Dead code with short varlenas in toast_save_datum()

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: Dead code with short varlenas in toast_save_datum()
Дата
Msg-id aKF2DMi2vjQC5dOp@paquier.xyz
обсуждение исходный текст
Ответ на Re: Dead code with short varlenas in toast_save_datum()  (Nikhil Kumar Veldanda <veldanda.nikhilkumar17@gmail.com>)
Список pgsql-hackers
On Sat, Aug 16, 2025 at 02:34:02AM -0700, Nikhil Kumar Veldanda wrote:
> Thanks for the guidance. I’ve updated the isolation test to use a CTAS
> capturing (id, chunk_id) pre-CLUSTER and added a post-CLUSTER join to
> verify the chunk IDs match. I also reduced the number of tuples to 1.
>
> Please find the attached patch for your review. Thanks

Cool, thanks for the new patch.  The structure looks OK.  There were
two things that itched me a bit:
- Instead of reporting the number of tuples where the chunk IDs do not
match across the rewrites, I have rewritten the query to report the
serial IDs, instead.
- Making sure that the CTAS holds some data, matching with the number
of tuples inserted.  A count(*) was enough for that.
--
Michael

Вложения

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