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 1uNWdE-003lt3-Jb for pgsql-general@arkaria.postgresql.org; Fri, 06 Jun 2025 12:57:12 +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 1uNWdA-009qAR-KS for pgsql-general@arkaria.postgresql.org; Fri, 06 Jun 2025 12:57:09 +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 1uNWdA-009q7R-81 for pgsql-general@lists.postgresql.org; Fri, 06 Jun 2025 12:57:08 +0000 Received: from mail-wm1-x329.google.com ([2a00:1450:4864:20::329]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uNWd8-000Y0a-2d for pgsql-general@lists.postgresql.org; Fri, 06 Jun 2025 12:57:08 +0000 Received: by mail-wm1-x329.google.com with SMTP id 5b1f17b1804b1-451d6ade159so18324125e9.1 for ; Fri, 06 Jun 2025 05:57:05 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec.at; s=google; t=1749214624; x=1749819424; 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=m2QeXvdhQBvWNdv03j9OZyD5F/B48JtMjOUDi0ySHbI=; b=GUFjreNFxDRN+4rnFSLizvGRyL6zB21gNWOmMwVd9TFkcr5R2aFtRJqeMrCFRDHLFN KOIMG36XViCwSKsTGROza5wRmvCzIoe5v0tq5YLsDpLoOakNLDxT2twUDa4e3me10kXV Hx7OgMA5PaTC2kILNCr5QHQNjjdEgMfm1pqng12p8EEmWTyoWW9K6LlOEJp8dFwx1DDh TPDlEeXfh4fFA6FvBYGnUgMV392PsE7dhdTNnLYKcXyrd0bsHXjOZIuuZjJm1l185qhm LPZZJHl2oE43+sq+uQ9nYXUlrSspoyM/xLeE9GxZxTV6/hFgA+kDLf5YFT5DCxNt3ZLP Mp6g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1749214624; x=1749819424; 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=m2QeXvdhQBvWNdv03j9OZyD5F/B48JtMjOUDi0ySHbI=; b=tSPFYBD7MDHmGgQyflbt126y6nTm3votrQURcbuxzFXHYWT1EkhZyM++rjhYAFcWVo d2ZE8+tBwUBfIlKAkvIbXOHDG1QUBXqxH+EKy7bQ9v8+6iUBuR6wnBJXB0CHF7FdjL7G 7/Q6U/hAayn/FEOZklpN/bk88o3mPKPtuMOqijvFFvjR6GZsA6zG0mMv8llZvf6QoY96 QUkrgapEcXGsO1TQZM2ovSdU0ikdRKfeVCmojqx4Bjm4k4EVm7Aprwi/uA0R4D5tNyia vGYWLy7jH4j2m3ByPhrcQnmuiA6knxkBvAq+Ao57C8U9RKb6Z2aID/Eqd8MlICum9fDo iPUw== X-Forwarded-Encrypted: i=1; AJvYcCVlsS9RaN4cy5dd/zeagysPTtXf1TfJ246UFe/9U7BSua9RtC1bgL+RX971Ic+MfG5XbE2U+GXzjAG7AbDq@lists.postgresql.org X-Gm-Message-State: AOJu0YxV2K7GNHdnHXcwBrNgxK72hbcibILyvhXrwYQtgd7ATXeqBRvE qgt1t0wX6a0S/UD408aMgpfwdu39YzBWM7n3PjkfYTM8W58oFhj96sb19UpYnC5g138= X-Gm-Gg: ASbGncuSN+0TsJTlIMsMxaBSBcmmND+11KsXpBBSeRsBjPKJ8AjPhD0jzNzzD3uFJB5 J07d3IefpyRggN9tZ57jpaDctmshZJvel1Gv6fZQomv839Mb89mgVWCEB+x00nqME5YHafz1Oj2 l7puVsNX+v8fpynx86i2vNbDXuhlCTfXf6Q6Yn+0DA6rjLWhEJFzp0NAKi9YlBpaL3I6fYpiTXc NS0fK47xh/hgarQRm7v7ZJu1u4Im3OhMtcWVStR/QoI0TDzWBXtUZTlbQQQ2OSf8HtTH6pXC0jM 8yclZLUu+y2TaFCDx4Mkjp8P0AnWC2IrRq2iSvBQciWsS9c54tXDTRr5VvPtwUjyIly5vi4JJpy 36w== X-Google-Smtp-Source: AGHT+IGvjfw+lYb4WjmXOOjjxoOwfXL1Pg2PrwcZDSIoFlI9caEzExQbQ14ntKnnjGhBZLAcB0TybA== X-Received: by 2002:a05:600c:8b14:b0:43c:f8fc:f697 with SMTP id 5b1f17b1804b1-4520139a3b3mr36325885e9.9.1749214623687; Fri, 06 Jun 2025 05:57:03 -0700 (PDT) Received: from laurenz.albe-K4N0CV00F97414D ([88.128.88.73]) by smtp.gmail.com with ESMTPSA id ffacd0b85a97d-3a532435f94sm1827142f8f.60.2025.06.06.05.57.03 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Fri, 06 Jun 2025 05:57:03 -0700 (PDT) Message-ID: <65a54f809d0339d9d6021c35f7fa14fc20a7f2e6.camel@cybertec.at> Subject: Re: Regarding fillfactor use case for only delete ops From: Laurenz Albe To: Durgamahesh Manne , pgsql-general Date: Fri, 06 Jun 2025 14:57:02 +0200 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.56.2 (3.56.2-1.fc42) MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Fri, 2025-06-06 at 14:10 +0530, Durgamahesh Manne wrote: > Can we generate a fill factor for tables that have delete ops ? >=20 > Does the fill factor really work and help to minimize the bloat for table= s that have delete ops? >=20 > I have parent table with weekly partitions So for every week 50 to 60 gb = of bloat generates and autovacuum params already in place for child tables= =C2=A0 Nothing can ever avoid bloat caused by DELETE, except partitioning in a way that you can drop a partition rather than running DELETE. Yours, Laurenz Albe