pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedvacuuming postgresql15 issues
3+ messages / 3 participants
[nested] [flat]
* vacuuming postgresql15 issues
@ 2023-11-08 14:17 Benjamin Acquaye <benjaminacquaye2@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: Benjamin Acquaye @ 2023-11-08 14:17 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi all,
I am trying to clean our database tuples with a manual vacuum but it's not
working any help
"n_dead_tup" 74 17 1 1 6 8 6 8 16 9
thanks
Ben
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: vacuuming postgresql15 issues
@ 2023-11-08 14:50 Keith Fiske <keith.fiske@crunchydata.com>
parent: Benjamin Acquaye <benjaminacquaye2@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Keith Fiske @ 2023-11-08 14:50 UTC (permalink / raw)
To: Benjamin Acquaye <benjaminacquaye2@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
On Wed, Nov 8, 2023 at 9:18 AM Benjamin Acquaye <benjaminacquaye2@gmail.com>
wrote:
> Hi all,
> I am trying to clean our database tuples with a manual vacuum but it's not
> working any help
>
> "n_dead_tup" 74 17 1 1 6 8 6 8 16 9
>
> thanks
> Ben
>
Check for long running transactions. Vacuum can only clean up dead rows if
there are no transactions running that could possibly need to see those old
rows. The following query will show all currently running transactions, in
order of transaction age along with an additional column to show their
runtime.
SELECT *, now() - xact_start AS xact_runtime FROM pg_stat_activity WHERE
state <> 'idle' ORDER BY xact_start;
--
Keith Fiske
Senior Database Engineer
Crunchy Data - http://crunchydata.com
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: vacuuming postgresql15 issues
@ 2023-11-08 21:00 Laurenz Albe <laurenz.albe@cybertec.at>
parent: Benjamin Acquaye <benjaminacquaye2@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: Laurenz Albe @ 2023-11-08 21:00 UTC (permalink / raw)
To: Benjamin Acquaye <benjaminacquaye2@gmail.com>; pgsql-admin@lists.postgresql.org
On Wed, 2023-11-08 at 09:17 -0500, Benjamin Acquaye wrote:
> I am trying to clean our database tuples with a manual vacuum but it's not working any help
https://www.cybertec-postgresql.com/en/reasons-why-vacuum-wont-remove-dead-rows/
Yours,
Laurenz Albe
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-11-08 21:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-08 14:17 vacuuming postgresql15 issues Benjamin Acquaye <benjaminacquaye2@gmail.com>
2023-11-08 14:50 ` Keith Fiske <keith.fiske@crunchydata.com>
2023-11-08 21:00 ` Laurenz Albe <laurenz.albe@cybertec.at>
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