From: | Mike <miketheman(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Subject: | Fwd: Emit namespace in post-copy output |
Date: | 2021-06-22 22:07:53 |
Message-ID: | CAMerE0oz+8G-aORZL_BJcPxnBqewZAvND4bSUysjz+r-oT1BxQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
When running a VACUUM or CLUSTER command, the namespace name is not part of
the emitted message.
Using `vacuumdb` CLI tool recently with multiple jobs, I found that
reading the output messages harder to match the relations with their
namespaces.
Example:
INFO: vacuuming "sendgrid.open"
INFO: vacuuming "mailgun.open"
...
INFO: "open": found 0 removable, 31460776 nonremovable row versions in
1358656 pages
DETAIL: 0 dead row versions cannot be removed yet.
CPU 31.35s/261.26u sec elapsed 1620.68 sec.
...
In this example. the user can't readily tell which `open` relation was
completed.
Attached is a patch using existing functions to include the namespace in
the output string.
Looking forward to feedback!
-Mike Fiedler
Attachment | Content-Type | Size |
---|---|---|
0001-emit-namespace-in-post-copy-output.patch | application/x-patch | 2.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2021-06-22 22:14:52 | Re: Pipeline mode and PQpipelineSync() |
Previous Message | Tom Lane | 2021-06-22 21:11:29 | Re: Reducing the cycle time for CLOBBER_CACHE_ALWAYS buildfarm members |