Hello, At Wed, 2 Dec 2015 15:48:20 -0300, Alvaro Herrera <alvhe...@2ndquadrant.com> wrote in <20151202184820.GL2763@alvherre.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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
