Re: Howdoes; pg; index; page; optimize; dead; tuples?;

Поиск
Список
Период
Сортировка
От Jonah H. Harris
Тема Re: Howdoes; pg; index; page; optimize; dead; tuples?;
Дата
Msg-id CADUqk8UWt08dx6QEOHioiCnNqEwsuz-+tG4EYKQLHURo6-A0Ew@mail.gmail.com
обсуждение исходный текст
Ответ на Howdoes; pg; index; page; optimize; dead; tuples?;  ("jacktby@gmail.com" <jacktby@gmail.com>)
Список pgsql-hackers
On Wed, Apr 19, 2023 at 9:40 PM jacktby@gmail.com <jacktby@gmail.com> wrote:
As far as I know, when a index page is full, if you insert a new tuple here, you will split it into two pages.
But pg won't delete the half tuples in the old page in real. So if there is another tuple inserted into this old
page, will pg split it again? I think that's not true, so how it solve this one? please give me a code example,thanks

This is not how the hackers list works; you need to do your own research. The Postgres code is pretty straightforward and giving you examples in isolation makes no sense. If you want to understand how things actually work, you need to read the code in context and understand how the system works, minimally, at a component level.



--
Jonah H. Harris

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

Предыдущее
От: Melanie Plageman
Дата:
Сообщение: Re: Remove io prefix from pg_stat_io columns
Следующее
От: "Zhijie Hou (Fujitsu)"
Дата:
Сообщение: RE: Support logical replication of DDLs