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 1r0pfT-0083Zl-Ud for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 21:00:55 +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 1r0pfS-007izP-C2 for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 21:00:54 +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.94.2) (envelope-from ) id 1r0pfS-007izC-1T for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 21:00:54 +0000 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0pfP-004cvz-Eo for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 21:00:52 +0000 Received: by mail-wr1-x430.google.com with SMTP id ffacd0b85a97d-32f737deedfso64224f8f.3 for ; Wed, 08 Nov 2023 13:00:51 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20230601.gappssmtp.com; s=20230601; t=1699477249; x=1700082049; darn=lists.postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=VzZUliy38N+qWjjWvfmCOYBY5Uk48XI1py5vaZboQlc=; b=yxtJep6Q6C2wUU5F8yHHZExyHYmdWf86icC4Gpq/ESCQ5WdAbYhYJlTtcFc2PtLJY1 hJCqdAT3z15I4SmnyFpC6Tm1KXlZZ6esFF+ruHde91DVVQ1sAFfjX74qSrrFfMrEnlB4 GZZ3gbCZqqVmiMGxUvKteQgkrXhwW8VfEurSDLCkAwmoCxjHvuBj0rjPjbtJ/6Dr9OTa Ji3KIRiuhQNdNvj934zBXlU/y1kbeRIsbNWUvDZ+1rHIZROIMVHQxdZM5NipAMc6W03M VtRlvHrZKIRzYgJvY33LvJl9s8gU+KUV91M+U8TsGnsb9h/bU5mnBZ8BOJSZdGVGDF3y 3wpA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699477249; x=1700082049; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=VzZUliy38N+qWjjWvfmCOYBY5Uk48XI1py5vaZboQlc=; b=f4GqvbJxg7Es2iijmxyieDtZgOe/NNiHUY+HN0pR4ichBCf7lqWnGgfeOIMc7HBFRG xYWC2TWzSMIBlT/pHVgzHFt/7bzf9kSuNmZfjozcbr1pf00YBk2Y78ycGoSP6+/3RtYx imGe6OX2mVZnYm1r5Nm+0Waejhay9Hk0qOJkkkFAN17UZwjFfo4ONWuLLEE3vuIoubQw Hpqv1lZzNRKPyk25b5ao9qvBrjxbKbgbJ9/iO5AqFynZKKSXeUy0rO/qqykwBORl5ZrQ ch/nVXmmsRY0UCkEIUAPajFLsIK2wCEKsCEfhekdpJkh/upItr0/JDB7is/q/B3+wWKj 05yQ== X-Gm-Message-State: AOJu0YxtgTqTU44oD1/H/NI9IiMSeoftlw5YF+uZZvamDiuS6YQwq+Cj gvRLfd7D00vsRtZa7pruKyS0fA== X-Google-Smtp-Source: AGHT+IEKoNkJwxCqV8ZDjJqNTIs0zvJAV/J1j888k4sYXBuLJChS9zLkzNEJ+YtCSXrxuqrFAnSjVQ== X-Received: by 2002:a05:6000:1f83:b0:32f:7867:112 with SMTP id bw3-20020a0560001f8300b0032f78670112mr3048020wrb.13.1699477248830; Wed, 08 Nov 2023 13:00:48 -0800 (PST) Received: from localhost.localdomain ([2001:871:260:ea1f:cf3b:8147:9c04:e8f1]) by smtp.gmail.com with ESMTPSA id o5-20020a056000010500b00327bf4f2f14sm5765534wrx.88.2023.11.08.13.00.48 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 08 Nov 2023 13:00:48 -0800 (PST) Message-ID: Subject: Re: vacuuming postgresql15 issues From: Laurenz Albe To: Benjamin Acquaye , pgsql-admin@lists.postgresql.org Date: Wed, 08 Nov 2023 22:00:48 +0100 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.48.4 (3.48.4-1.fc38) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2023-11-08 at 09:17 -0500, Benjamin Acquaye wrote: > I am trying to clean our database tuples with a manual vacuum but it's no= t working any help https://www.cybertec-postgresql.com/en/reasons-why-vacuum-wont-remove-dead-= rows/ Yours, Laurenz Albe