Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mFfM8-0002ba-A8 for pgsql-admin@arkaria.postgresql.org; Mon, 16 Aug 2021 16:20:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mFfM7-00088n-9Y for pgsql-admin@arkaria.postgresql.org; Mon, 16 Aug 2021 16:20:55 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mFfM7-00088d-0q for pgsql-admin@lists.postgresql.org; Mon, 16 Aug 2021 16:20:55 +0000 Received: from mail-qk1-x734.google.com ([2607:f8b0:4864:20::734]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mFfM5-0001EA-8a for pgsql-admin@lists.postgresql.org; Mon, 16 Aug 2021 16:20:54 +0000 Received: by mail-qk1-x734.google.com with SMTP id t66so19707056qkb.0 for ; Mon, 16 Aug 2021 09:20:53 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:date:subject:message-id :to; bh=FPw16SKzZ9oB+1i60NdDlIBbGhgfoXsn3wQS6c2mqw4=; b=bgvbbi65PjueP8yaWOlYCCEeBre73LnUbJRNJD57OVzWwBx4JGCvZGudl2T3zggfgi tK1kWGH3WCccbmo8xvMCZmRKBYvnJVQuUajfuEzx8zQUV4VWGAghoWYskBmxecgiBT/p Q1dTP8v1WKj/ypmcyQLOf8UWBSp9jQRz9wr2U5z+J+QKU18jYOwrrGKGA/dG+I+g3uTM jI8/cUu0esPtTUFpe5vY+tO6O6Fm5mFuUN9VgOPDIIFYHw728So15nAIPCHyn5Ik6Yl9 rFTSO8flP5UVtTjMNHEQow6rTBTYOWNOextuPVZoEIghr7MNYKmIi0vMgQlIbldjihJ+ TloQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version:date :subject:message-id:to; bh=FPw16SKzZ9oB+1i60NdDlIBbGhgfoXsn3wQS6c2mqw4=; b=MDGQDvqlJIfGwdJUqsHr7Ps0UvjGF2zr/oWNWVhHPnLeV0Z5tof8awmrySl4o0EtoW EZ6eGSe/sDdRQrbjvcIKbrtD7dN6Fth5eidjQnvci4q6viTb+1Sa0vYFjl1Que7u2RNI JzpdrUwWsX5LHsdmR05HoPOgjYJnCTShHicpJVofmqmUJcQZhPuaGqYL1ofbkuSKM6bI 5dRtev5Kcg9MdVgHnvX3AjXo+xiWm03LiwYc02aQI5e25KbJPGGt7df2AYH9k5NMNp4/ oqg55JZAE32Jb5sb0PpOGWAIHvQscwRORWoNWsSjiceIqMMbDd1OoF4NrroIcl2wDwvp 50ow== X-Gm-Message-State: AOAM5321u6N0VEI21VCD+tVu+uRhaCl3F8Nt0AZfBBGka7vWYvxBQ/Tf V717dqj98Kq2t+TxTyfSaR6npc3O49A= X-Google-Smtp-Source: ABdhPJwD+zrYaep58j8g6b4wxuNgzLbsbaeThM+yz0UNV9ffcogAW8jNXQ1GMkBiVsl3sxsr5y/xyg== X-Received: by 2002:a37:a2d7:: with SMTP id l206mr16765383qke.62.1629130851570; Mon, 16 Aug 2021 09:20:51 -0700 (PDT) Received: from smtpclient.apple ([2600:1015:b047:a346:7db4:1339:cd7f:935a]) by smtp.gmail.com with ESMTPSA id a14sm1892472qtb.57.2021.08.16.09.20.50 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 16 Aug 2021 09:20:51 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: srijith s Mime-Version: 1.0 (1.0) Date: Mon, 16 Aug 2021 12:20:49 -0400 Subject: After vacuum db size is increasing Message-Id: <7C3DCEF8-BBCF-4E92-B330-1D83121E638B@gmail.com> To: pgsql-admin@lists.postgresql.org X-Mailer: iPhone Mail (18F72) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi Postgres Admins=20 Any help is much appreciated . When i am running vacuum full, the database s= ize is getting increased a lot, my database was around 100gb and when i did v= acuum full on the large table ( which consume 95% of data in the database) ,= database size become 200+ gb , then i did a full vacuum on the database its= elf and that made the db grow to 300+gb =F0=9F=99=84 and filled my data driv= e . The large table size is showing only 80gb.=20 I am running Postgres on windows. Anybody know why its behaving like this=20= Thanks in advance Regards Sri=20 Sent from my iPhone=