Re: [PROPOSAL] VACUUM Progress Checker. - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [PROPOSAL] VACUUM Progress Checker.
Date
Msg-id 20151202184820.GL2763@alvherre.pgsql
Whole thread Raw
In response to Re: [PROPOSAL] VACUUM Progress Checker.  (Vinayak <vinpokale@gmail.com>)
Responses Re: [PROPOSAL] VACUUM Progress Checker.  (Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>)
List pgsql-hackers
Vinayak wrote:

> In the vacuum progress, column table_name is showing first 30 characters of
> table name.
> postgres=# create table test_vacuum_progress_in_postgresql(c1 int,c2 text);
> postgres=# select * from pg_stat_vacuum_progress ;
> -[ RECORD 1 ]-------+------------------------------
> pid                 | 12284
> table_name          | public.test_vacuum_progress_i

Actually, do we really need to have the table name as a string at all
here?  Why not just report the table OID?  Surely whoever wants to check
the progress can connect to the database in question to figure out the
table name.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: [PROPOSAL] VACUUM Progress Checker.
Next
From: Pavel Stehule
Date:
Subject: broken tests