Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppJJ8-0005nf-I3 for pgsql-general@arkaria.postgresql.org; Thu, 20 Apr 2023 01:41:58 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ppJJ7-0002Yi-IM for pgsql-general@arkaria.postgresql.org; Thu, 20 Apr 2023 01:41:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ppJJ7-0002YZ-7i for pgsql-general@lists.postgresql.org; Thu, 20 Apr 2023 01:41:57 +0000 Received: from mail-pf1-x442.google.com ([2607:f8b0:4864:20::442]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1ppJJ4-000nBE-S3 for pgsql-general@lists.postgresql.org; Thu, 20 Apr 2023 01:41:56 +0000 Received: by mail-pf1-x442.google.com with SMTP id d2e1a72fcca58-63b9f00640eso102972b3a.0 for ; Wed, 19 Apr 2023 18:41:54 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1681954914; x=1684546914; h=message-id:mime-version:subject:to:from:date:from:to:cc:subject :date:message-id:reply-to; bh=FfXJ/0WAX0B4h5n/YMXSK4dfXkp705/9i5o4pRKoczE=; b=Jn08O8vCm7EoVHzz82dhPlqYB8Wz0l2l1zjyaoN+dVO499NjLh40q9bZHxAPdOfVRk bWwOAAY/jpS3kYN4ArdHvlqUOc5fjSvxm9CE90oPsSqFdsjN+LTLDpnCJdg5OXsIh2GW mFWHvMEA99XQ1STXumAhrcDbCPdsgJ2xTK33Xch1tgd1WJmgD4Js5EBRAM/WMZnXYDC2 O0IJaDrdcfy3hgCFNufM1WzbxksiIBAzo+f0hNO2g6z6v5kjhbhfk5HMZ7szZfwsjvAF 3XtaUHarV5ljmWhRIdoD/32dcdR2o762Y6jvddeEr3vl3k72soDgyCuW/GJ3VkZDGEkt Cb5w== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1681954914; x=1684546914; h=message-id:mime-version:subject:to:from:date:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=FfXJ/0WAX0B4h5n/YMXSK4dfXkp705/9i5o4pRKoczE=; b=AOobHlisK2RO9WrfcVxLia/7hQYHJ8fakIFemojuADSqFiiZvME+jKO8iwf+zJlvnK 72VqYd6Uq9eEjSU+cTHlQNhumhIhY2dhfyZb0TwZXx5ZWS91gM8mw8qJpjwVA2JbXIFg b7fMgAqYVPNejq/Vlfa0nSHU3i84p6QLM5xrlI51v9hSuRU/96RxiinppaFMnW9so7Xw SUiVVUZHOUgRA6AaBsjzG2Du/rhjFS/lkKId8ipgkxG4/NxscPFsQvL95+lUS0s9ff0h mowvEZkQdKR+SvXlc7RanYaKjvgzfKLwm3ZrFTaqOR9ud/PtdfD/nFcnkH7y2p1KzZe6 iSig== X-Gm-Message-State: AAQBX9dXECY7uWhlXO7BLEXeK3mBoRik4wbH5djY/2ew+tgzZvMoL8ib MGQnOuN2XBjPcaBHlXntNVVN2yKSoPqcRkJkMFo= X-Google-Smtp-Source: AKy350ZuMqeQbM2o2JDDVWrrXv5wWQC1KSrsZ1y4HdxUKo8r+ywgn9vC4nvW+Z6mZQBdhBpS7rj1mA== X-Received: by 2002:a05:6a00:a06:b0:63d:2d6a:47be with SMTP id p6-20020a056a000a0600b0063d2d6a47bemr10285864pfh.2.1681954913729; Wed, 19 Apr 2023 18:41:53 -0700 (PDT) Received: from LAPTOP-6BJT67H1 ([2406:da18:38:2100:c325:4d39:d6a5:cb77]) by smtp.gmail.com with ESMTPSA id s23-20020a62e717000000b005aa60d8545esm47921pfh.61.2023.04.19.18.41.52 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Wed, 19 Apr 2023 18:41:53 -0700 (PDT) Date: Thu, 20 Apr 2023 09:41:52 +0800 From: "jacktby@gmail.com" To: pgsql-general Subject: How does pg index page optimize dead tuples? X-Priority: 3 X-GUID: 3C35E0E6-E006-4ECA-B43D-D5FC93B11193 X-Has-Attach: no X-Mailer: Foxmail 7.2.25.213[cn] Mime-Version: 1.0 Message-ID: <2023042009415111127413@gmail.com> Content-Type: multipart/alternative; boundary="----=_001_NextPart143403542544_=----" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. ------=_001_NextPart143403542544_=---- Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: base64 QXMgZmFyIGFzIEkga25vdywgd2hlbiBhIGluZGV4IHBhZ2UgaXMgZnVsbCwgaWYgeW91IGluc2Vy dCBhIG5ldyB0dXBsZSBoZXJlLCB5b3Ugd2lsbCBzcGxpdCBpdCBpbnRvIHR3byBwYWdlcy4NCkJ1 dCBwZyB3b24ndCBkZWxldGUgdGhlIGhhbGYgdHVwbGVzIGluIHRoZSBvbGQgcGFnZSBpbiByZWFs LiBTbyBpZiB0aGVyZSBpcyBhbm90aGVyIHR1cGxlIGluc2VydGVkIGludG8gdGhpcyBvbGQNCnBh Z2UsIHdpbGwgcGcgc3BsaXQgaXQgYWdhaW4/IEkgdGhpbmsgdGhhdCdzIG5vdCB0cnVlLCBzbyBo b3cgaXQgc29sdmUgdGhpcyBvbmU/IHBsZWFzZSBnaXZlIG1lIGEgY29kZSBleGFtcGxlLHRoYW5r cy4NCg0KDQpqYWNrdGJ5QGdtYWlsLmNvbQ0K ------=_001_NextPart143403542544_=---- Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable