Re: [PROPOSAL] VACUUM Progress Checker.

Hello,

At Wed, 2 Dec 2015 15:48:20 -0300, Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote in <20151202184820(dot)GL2763(at)alvherre(dot)pgsql>
> 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.

I thought the same thing but found that the same kind of view
(say, pg_stat_user_tables) has separate relanme and shcemaname in
string (not a qualified name, though).

Apart from the representation of the relation, OID would be
better as a field in beentry.

regards,

--
Kyotaro Horiguchi
NTT Open Source Software Center