From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: raut.akshay89@gmail.com
Subject: BUG #18419: Auto Vacuum In PostgreSQL 10.21
Date: Wed, 03 Apr 2024 12:32:12 +0000
Message-ID: <18419-b07f7f19ff1227a2@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18419
Logged by: Akshay Raut
Email address: raut.akshay89@gmail.com
PostgreSQL version: Unsupported/Unknown
Operating system: Windows 10
Description:
We are using PostgreSQL 10.21 in which we are deleting a few records
periodically but we observed that the auto vacuum is not getting executed on
all the tables.
Due to this, we are not able to get the space held by the dead rows back to
the database and at some point in time our system runs out of space.
All the tables have adequate data and the deleted rows are also beyond the
scale factor and auto vacuum threshold.
Is this a known issue with PostgreSQL and is there any solution to resolve
this?
This issue has become very critical for us and any help will be highly
appreciated.
Thanks.
Regards,
Akshay Raut
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-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, raut.akshay89@gmail.com
Subject: Re: BUG #18419: Auto Vacuum In PostgreSQL 10.21
In-Reply-To: <18419-b07f7f19ff1227a2@postgresql.org>
* 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