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