scripts
Your help is appreciated. If you have additional ideas, I'm all ears.
Thanks,
Senor
From: Laurenz Albe
Sent: Thursday, April 20, 2023 11:39 PM
To: senor ; pgsql-general@lists.postgresql.org
Subject: Re: vacuum TOAST tables
On Fri, 2023-04-21 at
On Fri, 2023-04-21 at 04:37 +, senor wrote:
> PostgreSQL v11.19-1PGDG.rhel7 (upgrading to 12+ is so far only talk)
> CentOS 7.9
>
> If I understand correctly, autovacuum handles tables and their associated
> TOAST tables separately
> but a manual vacuum will also vacuum the TOAST.
That is co
Hi All,
PostgreSQL v11.19-1PGDG.rhel7 (upgrading to 12+ is so far only talk)
CentOS 7.9
I see various recommendation for queries to return the tables most in need of a
vacuum that exclude the TOAST tables with something like:
...AND n.nspname NOT IN ('pg_toast')
My real issue is autovacuum not
