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

This is a multi-part message in MIME format.

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

QXMgZmFyIGFzIEkga25vdywgd2hlbiBhIGluZGV4IHBhZ2UgaXMgZnVsbCwgaWYgeW91IGluc2Vy
dCBhIG5ldyB0dXBsZSBoZXJlLCB5b3Ugd2lsbCBzcGxpdCBpdCBpbnRvIHR3byBwYWdlcy4NCkJ1
dCBwZyB3b24ndCBkZWxldGUgdGhlIGhhbGYgdHVwbGVzIGluIHRoZSBvbGQgcGFnZSBpbiByZWFs
LiBTbyBpZiB0aGVyZSBpcyBhbm90aGVyIHR1cGxlIGluc2VydGVkIGludG8gdGhpcyBvbGQNCnBh
Z2UsIHdpbGwgcGcgc3BsaXQgaXQgYWdhaW4/IEkgdGhpbmsgdGhhdCdzIG5vdCB0cnVlLCBzbyBo
b3cgaXQgc29sdmUgdGhpcyBvbmU/IHBsZWFzZSBnaXZlIG1lIGEgY29kZSBleGFtcGxlLHRoYW5r
cy4NCg0KDQpqYWNrdGJ5QGdtYWlsLmNvbQ0K

------=_001_NextPart644671453732_=----
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>As far as I know, when a index pag=
e is full, if you insert a new tuple here, you will split it into two page=
s.</div>=0A<div>But pg won't delete the half tuples in the old page in rea=
l. So if there is another tuple inserted into this old</div><div>page, wil=
l pg split it again? I think that's not true, so how it solve this one? pl=
ease give me a code example,thanks.</div><hr style=3D"WIDTH: 210px; HEIGHT=
: 1px" color=3D"#b5c4df" size=3D"1" align=3D"left">=0A<div><span><div styl=
e=3D"MARGIN: 10px; FONT-FAMILY: verdana; FONT-SIZE: 10pt"><div>jacktby@gma=
il.com</div></div></span></div>=0A</body></html>
------=_001_NextPart644671453732_=------