Skip site navigation (1) Skip section navigation (2)

Re: Help tracking down problem with inserts slowing

From: Steve Wampler <swampler(at)noao(dot)edu>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>,Postgres-performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Help tracking down problem with inserts slowing
Date: 2003-12-08 15:14:53
Message-ID: 1070896493.20063.159.camel@weaver.tuc.noao.edu (view raw or flat)
Thread:
Lists: pgsql-performance
On Sun, 2003-12-07 at 09:52, Tom Lane wrote:
> Steve Wampler <swampler(at)noao(dot)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(at)noao(dot)edu
The gods that smiled on your birth are now laughing out loud.

In response to

Responses

pgsql-performance by date

Next:From: Tom LaneDate: 2003-12-08 15:35:49
Subject: Re: Help tracking down problem with inserts slowing
Previous:From: Hartmut RaschickDate: 2003-12-08 14:03:34
Subject: TRUNCATE veeeery slow compared to DELETE in 7.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group