Re: Howdoes; pg; index; page; optimize; dead; tuples?; - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: Howdoes; pg; index; page; optimize; dead; tuples?;
Date
Msg-id CADUqk8UWt08dx6QEOHioiCnNqEwsuz-+tG4EYKQLHURo6-A0Ew@mail.gmail.com
Whole thread Raw
In response to Howdoes; pg; index; page; optimize; dead; tuples?;  ("jacktby@gmail.com" <jacktby@gmail.com>)
List 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 by date:

Previous
From: Melanie Plageman
Date:
Subject: Re: Remove io prefix from pg_stat_io columns
Next
From: "Zhijie Hou (Fujitsu)"
Date:
Subject: RE: Support logical replication of DDLs