Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1vq3qh-003jYt-16
	for pgsql-general@arkaria.postgresql.org;
	Wed, 11 Feb 2026 06:37:20 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1vq3qf-002g6d-1q
	for pgsql-general@arkaria.postgresql.org;
	Wed, 11 Feb 2026 06:37:18 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1vq3qf-002g6V-0i
	for pgsql-general@lists.postgresql.org;
	Wed, 11 Feb 2026 06:37:18 +0000
Received: from mail-wr1-x42f.google.com ([2a00:1450:4864:20::42f])
	by magus.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.98.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1vq3qd-000000006jL-1qBt
	for pgsql-general@lists.postgresql.org;
	Wed, 11 Feb 2026 06:37:17 +0000
Received: by mail-wr1-x42f.google.com with SMTP id ffacd0b85a97d-4375d4fb4d4so1182918f8f.0
        for <pgsql-general@lists.postgresql.org>; Tue, 10 Feb 2026 22:37:14 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec.at; s=google; t=1770791834; x=1771396634; darn=lists.postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject
         :date:message-id:reply-to;
        bh=cTvdpHdySuhDu3OuBu1ZkZVE2xfoYwqJjGwAJSUEXXU=;
        b=Yeqm45pHRydzL0MMoDsfDYolv69HMgfHx6K2dJtqKdJjmHSCIN9MH6a+ekvwpswY8P
         vGerbYSPg8bOjkW9qB/3C91tk9dtZydsVt9vy2uTTZZyywjn1KK9H17a+M5OEqO/czso
         v/eVeFVmly0deNOCmIyfHZSkOu+NkbcJr1Nj8X7oFk/snPrHGq3yh5tSkkeNEXsRktUR
         kP0dCAI2FcSE2nfrkpvT3SGEYx5Rxhsh0cPmQ75ptndiCkivZNSEUTnn/slbynjM1F1B
         FfR0uDfXrxFgQEHShOSO6kreoMiQusZqGnlfzl95cUhlFi9tXFqt6Y086EyoeQguHB1g
         4UQg==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1770791834; x=1771396634;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg
         :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to;
        bh=cTvdpHdySuhDu3OuBu1ZkZVE2xfoYwqJjGwAJSUEXXU=;
        b=jnmcl5TH3BFIgPV7UbI/Va8rF1XXl4N+DY3hV9WTni51fEdeOXE7emZg+StHrb4g4R
         PVLQmm6uYnKA2D8Aj2JasJeIl50N3HCKhq7pJ0JZa2pAWC1qkEFBbCpJQfbT43xtMJYN
         Yasp98uen6EHZdMS4XMFxIRFxfBq7XRFT0vGa6A0BHp+p/fhHRdm6ZzK5ZHsBzWcIfPV
         9z57c67M8nwQA3cHRBmFJHAw0aDU4WEWDK85Pmekc9jz+3tRigA5Az5lZMNv5be7K/mH
         u7rUd51GdowtYwfiAeZ2qKgafjSXKhf+CDgEgLA4ebi/QYGWO2sR3fNJ8RFlTEeiPdQM
         D8Zg==
X-Gm-Message-State: AOJu0YwyQh5MLw1wbOjV/7esNk9JXbiiBYCD0tVP2RwKbNfhIz6pxPfh
	0EReJGSEDsEGhlchlxNfAeticUbeiXnlWqovPbzUr88QaFTquwRGVOJIaoKpN/WE+Ws=
X-Gm-Gg: AZuq6aKEoehRINf1OgQqIgTanXdb8DznjFgv89qWinvoC5BYXmQ+BRnCd7sWJrDfxzs
	G9cFea/todbJx1BvvCTm4iLPo1cphL/1HNFraeGno9RXC67nmn5kp5232hj+c6uGJAp9mfJwry3
	j8cbpXF4JwnU5qOc2sUCx0saIqpKDgjUygSBQ08OBlyyZMSaQ7XSAnBcbWHsdXljbW6Bj9zLyuP
	G6FU1nc7XJ8FE5xEtXoV1eHNxK45XaAczLyhtjkMeQQwG91ZpZ0lFLSJPTsSLhWkvkdOA3/+gQH
	4IAGfFytO77igST+83xAG0Cc3m28t1PG9lt2PqMilxMLSXHtEaTXyyu9Ee1+Tt3THbCcjQ9nO0A
	+K1yz52vaIPa8YWlROAl+EUu0114WuV/kdUllYQDPBg2179jBvjKX+U7yGltDINyVkOvJdtOLu6
	eX34GtiebFWtLgvZIo7HUMD0EKvYe8Q7+h242BaGDT10mI2Ok9SYXJIkaTEz+khs3HWD32tkLqW
	8gUkBdc6C9FbFqruZFoC15brzfP2DnSEQtpmRVxxRiS
X-Received: by 2002:a05:600c:3b85:b0:47e:e970:b4e4 with SMTP id 5b1f17b1804b1-4832021eac2mr252050585e9.29.1770791833626;
        Tue, 10 Feb 2026 22:37:13 -0800 (PST)
Received: from laurenz.albe-K4N0CV00F97414D (210.144.128.164.static.wline.lns.ent.cust.swisscom.ch. [164.128.144.210])
        by smtp.gmail.com with ESMTPSA id 5b1f17b1804b1-4835b958b6csm29894185e9.1.2026.02.10.22.37.13
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Tue, 10 Feb 2026 22:37:13 -0800 (PST)
Message-ID: <2d3a434fe195f2f06734f06a9d0dd0cbfa9b00e6.camel@cybertec.at>
Subject: Re: Fillfactor effectiveness on existing table
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Durgamahesh Manne <maheshpostgres9@gmail.com>
Cc: pgsql-general <pgsql-general@lists.postgresql.org>
Date: Wed, 11 Feb 2026 07:37:12 +0100
In-Reply-To: <CAJCZko+HNA++sW-a0cZWmPn7gPNDy2HKGXMSshMb5TFPzC5Qjw@mail.gmail.com>
References: 
	<CAJCZko+BFu4c4moqA5kMoJx3776xdYfEsxJQVNu_YYgrBmsCyQ@mail.gmail.com>
	 <8039d3e65e099b6046a48209fd1c194b1493fd8d.camel@cybertec.at>
	 <CAJCZko+HNA++sW-a0cZWmPn7gPNDy2HKGXMSshMb5TFPzC5Qjw@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.2 (3.58.2-1.fc43) 
MIME-Version: 1.0
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/2d3a434fe195f2f06734f06a9d0dd0cbfa9b00e6.camel%40cybertec.at>
Precedence: bulk

On Wed, 2026-02-11 at 07:58 +0530, Durgamahesh Manne wrote:
> Hi=C2=A0
> @Laurenz Albe=C2=A0
> offer=3D> SELECT relname AS table_name, n_tup_upd AS updates, n_tup_hot_u=
pd AS hot_updates FROM pg_stat_all_tables WHERE relname =3D 'market';=C2=A0
> table_name | updates | hot_updates=C2=A0
> market | 5997455764 | 3752865557

Did you read my e-mail?

Yours,
Laurenz Albe