Current message (9.0 - looking at pg_stat_activity query):
"autovacuum: VACUUM pg_toast.pg_toast_xx"
Suggested query/message:
"autovacuum: VACUUM pg_toast.pg_toast_x (base_table_name)"
Given that there is already an "autovacuum: " prefix it doesn't seem that
big a stretch to allow a suf
On Saturday, August 2, 2014, Phoenix Kiula wrote:
> Hi. I've been patient. PG is 9.0.17, updated via Yum yesterday.
>
> One of my large tables (101 GB on disk, about 1.1 billion rows) used
> to take too long to vacuum.
Too long for what? Rome wasn't build in a day, it might not get vacuumed
in
On 08/02/2014 07:37 PM, Phoenix Kiula wrote:
In your original post you said it was stopping on pg_class so now I am
confused.
No need to be confused. The vacuum thing is a bit tricky for laymen
like myself. The "pg_class" seemed to be associated to this table.
Anyway, even before the upgrade,
