Re: Help tracking down problem with inserts slowing

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.