pg.ddx.io pgsql-bugs@postgresql.org mailing list archivehelp / color / mirror / Atom feed
BUG #18419: Auto Vacuum In PostgreSQL 10.21 2+ messages / 2 participants [nested] [flat]
* BUG #18419: Auto Vacuum In PostgreSQL 10.21 @ 2024-04-03 12:32 PG Bug reporting form <noreply@postgresql.org> 2024-04-04 01:13 ` Re: BUG #18419: Auto Vacuum In PostgreSQL 10.21 David Rowley <dgrowleyml@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: PG Bug reporting form @ 2024-04-03 12:32 UTC (permalink / raw) To: pgsql-bugs@lists.postgresql.org; +Cc: raut.akshay89@gmail.com 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18419: Auto Vacuum In PostgreSQL 10.21 2024-04-03 12:32 BUG #18419: Auto Vacuum In PostgreSQL 10.21 PG Bug reporting form <noreply@postgresql.org> @ 2024-04-04 01:13 ` David Rowley <dgrowleyml@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: David Rowley @ 2024-04-04 01:13 UTC (permalink / raw) To: raut.akshay89@gmail.com; pgsql-bugs@lists.postgresql.org On Thu, 4 Apr 2024 at 11:08, PG Bug reporting form <noreply@postgresql.org> wrote: > > 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. > Is this a known issue with PostgreSQL and is there any solution to resolve > this? If you were doing something like calling pg_stat_reset() then the counters might be getting reset before they're high enough for autovacuum to care. Otherwise, perhaps autovacuum is running flat out due to badly tuned autovacuum settings. version 10 is out of support, so if there was some bug in that version, we wouldn't fix it anyway. v12 is the oldest supported version, currently. https://www.postgresql.org/support/versioning/ David ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-04-04 01:13 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2024-04-03 12:32 BUG #18419: Auto Vacuum In PostgreSQL 10.21 PG Bug reporting form <noreply@postgresql.org> 2024-04-04 01:13 ` David Rowley <dgrowleyml@gmail.com>
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