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
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 |