From: srijith s <udbdoctor@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: After vacuum db size is increasing
Date: Mon, 16 Aug 2021 12:20:49 -0400
Message-ID: <7C3DCEF8-BBCF-4E92-B330-1D83121E638B@gmail.com> (raw)
Hi Postgres Admins
Any help is much appreciated . When i am running vacuum full, the database size is getting increased a lot, my database was around 100gb and when i did vacuum 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 itself and that made the db grow to 300+gb 🙄 and filled my data drive .
The large table size is showing only 80gb.
I am running Postgres on windows. Anybody know why its behaving like this
Thanks in advance
Regards
Sri
Sent from my iPhone
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: udbdoctor@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: After vacuum db size is increasing
In-Reply-To: <7C3DCEF8-BBCF-4E92-B330-1D83121E638B@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox