Date: Thu, 20 Apr 2023 09:42:26 +0800
From: "jacktby@gmail.com" <jacktby@gmail.com>
To: pgsql-hackers <pgsql-hackers@lists.postgresql.org>
Subject: How does pg index page optimize dead tuples?
Mime-Version: 1.0
Message-ID: <2023042009422409511415@gmail.com>
Content-Type: multipart/alternative;
	boundary="----=_001_NextPart622142436637_=----"
Archived-At: <https://www.postgresql.org/message-id/2023042009422409511415%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.

------=_001_NextPart622142436637_=----
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: base64

QXMgZmFyIGFzIEkga25vdywgd2hlbiBhIGluZGV4IHBhZ2UgaXMgZnVsbCwgaWYgeW91IGluc2Vy
dCBhIG5ldyB0dXBsZSBoZXJlLCB5b3Ugd2lsbCBzcGxpdCBpdCBpbnRvIHR3byBwYWdlcy4NCkJ1
dCBwZyB3b24ndCBkZWxldGUgdGhlIGhhbGYgdHVwbGVzIGluIHRoZSBvbGQgcGFnZSBpbiByZWFs
LiBTbyBpZiB0aGVyZSBpcyBhbm90aGVyIHR1cGxlIGluc2VydGVkIGludG8gdGhpcyBvbGQNCnBh
Z2UsIHdpbGwgcGcgc3BsaXQgaXQgYWdhaW4/IEkgdGhpbmsgdGhhdCdzIG5vdCB0cnVlLCBzbyBo
b3cgaXQgc29sdmUgdGhpcyBvbmU/IHBsZWFzZSBnaXZlIG1lIGEgY29kZSBleGFtcGxlLHRoYW5r
cy4NCg0KDQpqYWNrdGJ5QGdtYWlsLmNvbQ0K

------=_001_NextPart622142436637_=----
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charse=
t=3Dus-ascii"><style>body { line-height: 1.5; }body { font-size: 14px; fon=
t-family: "Microsoft YaHei UI"; color: rgb(0, 0, 0); line-height: 1.5; }</=
style></head><body>=0A<div><span></span><div>As far as I know, when a inde=
x page is full, if you insert a new tuple here, you will split it into two=
 pages.</div><div>But pg won't delete the half tuples in the old page in r=
eal. So if there is another tuple inserted into this old</div><div>page, w=
ill pg split it again? I think that's not true, so how it solve this one? =
please give me a code example,thanks.</div></div><hr style=3D"width: 210px=
; height: 1px;" color=3D"#b5c4df" size=3D"1" align=3D"left">=0A<div><span>=
<div style=3D"MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt"><div>ja=
cktby@gmail.com</div></div></span></div>=0A</body></html>
------=_001_NextPart622142436637_=------