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 ) id 1vgSY5-00DHbO-0P for pgsql-general@arkaria.postgresql.org; Thu, 15 Jan 2026 18:58:25 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vgSY3-000JTb-38 for pgsql-general@arkaria.postgresql.org; Thu, 15 Jan 2026 18:58:24 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vgSVV-000Ev8-2T for pgsql-general@lists.postgresql.org; Thu, 15 Jan 2026 18:55:46 +0000 Received: from mail-dl1-x1243.google.com ([2607:f8b0:4864:20::1243]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vgSVT-000c6P-2W for pgsql-general@postgresql.org; Thu, 15 Jan 2026 18:55:45 +0000 Received: by mail-dl1-x1243.google.com with SMTP id a92af1059eb24-121bf277922so1663697c88.0 for ; Thu, 15 Jan 2026 10:55:44 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1768503343; x=1769108143; darn=postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=d0VLglPExjAg7DNTchK0VeEDXpkYG913zTmUMlH2HqU=; b=NQWrUlWjEhyhbmM1GnPgtMo+J2XJmkAQA6vUtieaqxMnG3RU+DSScZGbj5htuWpJPE ZXMk49bBG6vTvfZ3w6W1zXYiVJQFfoMIqm8EgklO11W6FHAf891KfobHbmDRDRWAGT7c XEU+94uP0vS/ttmRQh/qTfrSoZGx/MSp4ZZhxvz8Rh8kPYx5JA8k9o2Dk8GLrXxscRoi yH/id71TbkOj66xttf95zPcMWKIo7b0vUTBd9Ov8rKTzl7OxF70UrGbwQQlRmsAVUZbi nrQ0qmIfUpibCw5pVcNXJpvPGrQzUBk2NnexHtgseAX0/HaDjef3OI9tqlumpIBKDVpW f7Iw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1768503343; x=1769108143; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-gg:x-gm-message-state:from:to :cc:subject:date:message-id:reply-to; bh=d0VLglPExjAg7DNTchK0VeEDXpkYG913zTmUMlH2HqU=; b=QuoXCb7jsn1pdEAqCLW0+afxXN3gHNUQeq5y1RZw/o9Zs54VyMQBWL5nKI7whSB1dy kLpEDy6R0ERfwrXp/n21XsANagFVWwyNBzUNkL9civCcHI69AhMhgFA2UN33AM57evza iAKyWIYyXuu/0FWbTf5kb+ywseoI3QMgzNGca/EjacM0KbLomnRGFi4Q/GqfZ4YRXMwO U+fTYkKmmhDRjHNInC373sL5GnQbK6X9MYYZ7meL8YtBeJtFCOyealFD54INj045Ua7b z7BfwYGsSn8ULPXH0+O8icI2H9y50XS+zTuwFX22jqHBIcJjgeU4qqsqdWJ7UWV/mOkB 25Dg== X-Forwarded-Encrypted: i=1; AJvYcCVBGddcUhPbF2Jh59/Q+9s7IRVu+Z1GivRweMHYjfChZm0zkdTIxv85PCYYSTOmKPGgvOCwcWoqveMreoOr@postgresql.org X-Gm-Message-State: AOJu0YzmX3nye5C0cv8dY0OO/YYJDpmmRjdWpT+cjAOZT0EpxrdKBP3l SnbozEmK71w4Dx7U4TPuDXTVGOrveBa5pT+v19WiuJ9I4nKMcH4AP6lMWwq1f2WR X-Gm-Gg: AY/fxX5Xjt72e5lmwSU7+T6Q8UTDBbsck7CXZSop/SWReQxGeVga/k3HnRD6SobgA8h dYG7eYGrBTYSD9mTHXIGssZiXd2LEGr50fBmMYdHSvH009xzJRgwwnt5gJ8BF9z+j0OXHkC+jN2 s/EP+YermpydvQsOTqWz7d+4/rJ9kekFVHmBEbSYfKxFdlWCPU5JL1n8nVRTPvgZwHS0ffS9DOW M8//wHckTHCiVXLWyRi1QWz9Ep2s/V/0WKb6VeCoC/mO1UnErCi1K6aaG2XKmjsxNQkRo6epwnE CyJTJabfT+PSZMQq3iEoASaJVdBPmwYM6M9csBAtmWx0BHEqb7QZgrVtAWUVi/fzxfIHBvLS+6s nLeylsxM/9hSSl0YxxiS2d6cgwpY4gTs9pwJ5phILVdvIWCOuSsUXug0yJHl6L8HSAcUO2035Zn LxKiCmEVxTGJjvhqvapRoFxWaooprokgt9gUSPctA= X-Received: by 2002:a05:7022:248a:b0:119:e569:f61e with SMTP id a92af1059eb24-1244b35b54cmr210547c88.23.1768503343215; Thu, 15 Jan 2026 10:55:43 -0800 (PST) Received: from smtpclient.apple ([2601:681:4c01:7310:7df5:6100:d6ee:72a4]) by smtp.gmail.com with ESMTPSA id a92af1059eb24-1244aefa7c5sm366406c88.10.2026.01.15.10.55.42 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Thu, 15 Jan 2026 10:55:42 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: Rob Sargent Mime-Version: 1.0 (1.0) Subject: Re: How did VACUUM ANALYZE reclaim large TOAST bloat at disk level in PostgreSQL 16? Date: Thu, 15 Jan 2026 11:55:32 -0700 Message-Id: References: Cc: pramod gupta , pgsql-general In-Reply-To: To: Adrian Klaver X-Mailer: iPhone Mail (23C55) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Jan 15, 2026, at 11:52=E2=80=AFAM, Adrian Klaver wrote: >=20 > =EF=BB=BFOn 1/15/26 10:22, pramod gupta wrote: >> postgres@ANRPGTEST01:~$ echo $HOME >> /var/lib/postgresql >> postgres@ANRPGTEST01:~$ >=20 > Should have added to previous post: >=20 > Another thing to try is copy/move .pg_ai.config to your home directory and= run psql from there. >=20 > -- > Adrian Klaver > adrian.klaver@aklaver.com >=20 Is this a hijacked thread? >=20