vacuum toast loop?

From: gleeco <gleeco(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: vacuum toast loop?
Date: 2017-01-10 08:53:06
Message-ID: CADv14s-_fm=dbwAFSFPK-upEQh033Dh6zAML2UVP-Etzjnd+Sg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hello - i've a long-running manual vacuum on a big size table. It's many
TB db that has some toast. What is odd is that it keeps looping back on
the same toast / index, eg.

INFO: 00000: "pg_toast_17283": removed 178956683 row versions in 52264585
pages
DETAIL: CPU 737.22s/1145.35u sec elapsed 53850.35 sec.
LOCATION: lazy_vacuum_heap, vacuumlazy.c:1169
INFO: 00000: scanned index "pg_toast_17283_index" to remove 178956681 row
versions
DETAIL: CPU 89.90s/215.38u sec elapsed 4121.92 sec.
LOCATION: lazy_vacuum_index, vacuumlazy.c:1335
INFO: 00000: "pg_toast_17283": removed 178956681 row versions in 43893618
pages
DETAIL: CPU 421.92s/1084.34u sec elapsed 23879.84 sec.
LOCATION: lazy_vacuum_heap, vacuumlazy.c:1169
INFO: 00000: scanned index "pg_toast_17283_index" to remove 178956683 row
versions
DETAIL: CPU 95.21s/211.57u sec elapsed 3479.92 sec.
LOCATION: lazy_vacuum_index, vacuumlazy.c:1335
INFO: 00000: "pg_toast_17283": removed 178956683 row versions in 43957868
pages
DETAIL: CPU 459.10s/1202.59u sec elapsed 25266.61 sec.
LOCATION: lazy_vacuum_heap, vacuumlazy.c:1169

..and so on. Is this normal? If so, when does the toast vacuum cease?

thanks in advance!

-gleeco

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2017-01-10 13:04:28 Re: vacuum toast loop?
Previous Message Franklyn Edwin 2017-01-10 06:38:08 Re: Issue with pgAdmin4 UI