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.94.2) (envelope-from ) id 1uj0mV-001esH-Ps for pgsql-admin@arkaria.postgresql.org; Mon, 04 Aug 2025 19:23:36 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uj0mU-0049UG-OO for pgsql-admin@arkaria.postgresql.org; Mon, 04 Aug 2025 19:23:34 +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.94.2) (envelope-from ) id 1uj0mU-0049U8-CD for pgsql-admin@lists.postgresql.org; Mon, 04 Aug 2025 19:23:34 +0000 Received: from mail-yw1-x1130.google.com ([2607:f8b0:4864:20::1130]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uj0mS-000kcb-03 for pgsql-admin@lists.postgresql.org; Mon, 04 Aug 2025 19:23:34 +0000 Received: by mail-yw1-x1130.google.com with SMTP id 00721157ae682-71b6703ba32so37429237b3.3 for ; Mon, 04 Aug 2025 12:23:31 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1754335410; x=1754940210; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=NOXVyhbs7h3vc71bUGJfy4bJ//CF7s/bjC5wfn8eIOE=; b=ZRP3knduUvv1Lrpgcm1XwOHkcEjb8Q9YNP6UOu5HSDycfgBMmsBkLhDTYhI2qIg+7l 8WoBizD21K+6fOQcuCjB9rD0Uqm1ZjS35mRu0yor1g7kaR3j6QVgTUu27SpEMZoFqlQ7 QXYP0dytvOe9PTNo16M3QGXqY4wzU44yy01fPrwauBNYYACl9+tOPHmtYtnSUa3o2mLd PpEpNXUuRF1C3SwpJsHTqBKI2r1xK80Z/P6X3OZUaNkwRG1bRpCTFpH9kiK78vIXHkvm gk6lHWFsTjmxrV7kTwE1IZUJGZyZjp7rs6qbzCqMOM+SnKscnCLInRPU1wkeVF+Y1Sg2 oCeg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1754335410; x=1754940210; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=NOXVyhbs7h3vc71bUGJfy4bJ//CF7s/bjC5wfn8eIOE=; b=Tm/N5n+SBSU5Q46H5Uvo26ADtSZBpgl6Ljui7lwzfuejfcZhA/NZ/8kTnyc6G0vSdf NeTxckh2lEQKlOnnSiT9OU0+IDfjOe3OcrmEMbbKG+oWn1jqXd3aVvX6PXshE/ydcjfI iaw28LLcIyu8ODceT2FDiVvuvD60FewOX1OxOmCJL8EslC20rgTVNCAij8LQ/kfWC4uC 5aJBXxNFJ2iW5qTcoLjrx8Cfsm+xGG3o3zkLepm7wDjsim33Z24guNIyT20150EOm8Gm 28LtgyAo7IePR4bUReR4MP0rgknlA/6bZLwBUWv/lJbK2kDiPUkkdwgOitqP0JisEfqz sZHA== X-Gm-Message-State: AOJu0YwWeg0AfeAehnwXxt56Yidi79cd6lYlw6d9PEfBeVSPY2q15bTg DPBI+ZR1j3hXO7xZMxb6K5fkoKsHJ2kruuFHd+ZiqM21STUuyKn+V5onAmix+GN0eiEAD662hJm vcCO9+j/UzZDjEhOAWG+cTjQUpuUvTJQ= X-Gm-Gg: ASbGnctGtXS3vULGFCFEtt2IOhH5Okb3BIRfGmOFXsV0uPK1qrKCS29DKa0UkTyjEoJ qUrlRKvJxIKLeCqYWcAvXMTiZyj4Z1acpmzxc3BqUCspNimcZV0IfUngQcXzOCCo6ua850Yzpbb eGny85tv2xRLoaiQfWHfQxw/vkaPeQoRE82niXlsN1fwdxMgLmIRUCd3AZSnpIlZZIVzFoPw37/ T6+/UGeUfOnhSZb X-Google-Smtp-Source: AGHT+IFSM6Mi2qH4xhU3fnfCqk8xNpgEc/8A5rrlnDIc4QcdVh1/b5ZmO3AjI3uc4YuTzOWbZkjXWN/l96bTRPYNkGg= X-Received: by 2002:a05:690c:998e:b0:71a:1c50:8898 with SMTP id 00721157ae682-71b7f595144mr137823767b3.20.1754335410046; Mon, 04 Aug 2025 12:23:30 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Peter Gram Date: Mon, 4 Aug 2025 21:23:02 +0200 X-Gm-Features: Ac12FXyeAabEkKBCMzNvsIdVjJt6IxTLxoKQ3S82hcQ4QTyb-WSHqDGzfr4wC0A Message-ID: Subject: Re: Clearing of temp files is very slow in pg16 To: Ramakrishna Reddy Nandyala Cc: pgsql-admin@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000eecc5b063b8f0ae6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000eecc5b063b8f0ae6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Hi Are you sure that postgres uses all the memory that you have set as Huge Pages otherwise it is wasted and can not be used by anybody. This could be 25 % of your memory that is wasted in your configuration.