On Sun, 2003-12-07 at 09:52, Tom Lane wrote:
> Steve Wampler <swampler@noao.edu> 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.
VACUUM
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 -- swampler@noao.edu
The gods that smiled on your birth are now laughing out loud.
