On Sun, 2003-12-07 at 09:52, Tom Lane wrote:
> Steve Wampler <[EMAIL PROTECTED]> writes:
> > Hmmm, I have a feeling that's not as obvious as I thought...  I can't
> > identify the index (named 'id_index') in the output of vacuum verbose.
> In 7.2, the index reports look like
>       Index %s: Pages %u; Tuples %.0f.
> and should appear in the part of the printout that deals with their
> owning table.

Thanks, Tom.  Are there any reasons why it would not appear?:
farm.devel.configdb=# vacuum verbose attributes_table;
NOTICE:  --Relation attributes_table--
NOTICE:  Pages 1389: Changed 0, Empty 0; Tup 111358: Vac 0, Keep 0,
UnUsed 51.
        Total CPU 0.00s/0.02u sec elapsed 0.03 sec.
NOTICE:  --Relation pg_toast_1743942--
NOTICE:  Pages 0: Changed 0, Empty 0; Tup 0: Vac 0, Keep 0, UnUsed 0.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.

farm.devel.configdb=# \d attributes_table
             Table "attributes_table"
 Column |           Type           |   Modifiers   
 id     | character varying(64)    | not null
 name   | character varying(64)    | not null
 units  | character varying(32)    | 
 value  | text                     | 
 time   | timestamp with time zone | default now()
Indexes: id_index
Primary key: attributes_table_pkey
Triggers: trigger_insert

The odd thing is that I could have sworn it appeared yesterday...

Steve Wampler -- [EMAIL PROTECTED]
The gods that smiled on your birth are now laughing out loud.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?


Reply via email to