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

Re: Help tracking down problem with inserts slowing down...

From: Steve Wampler <swampler(at)noao(dot)edu>
To: Steve Wampler <swampler(at)noao(dot)edu>
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 down...
Date: 2003-12-07 14:52:35
Message-ID: 20031207145235.GA8734@weaver.tuc.noao.edu (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Dec 05, 2003 at 09:54:52PM -0500, Robert Treat wrote:
>...
> A vacuum verbose could give you a good indication if you need to reindex, 
> compare the # of pages in the index with the # in the table. 

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.
The closest I can find is:

NOTICE:  --Relation pg_index--
NOTICE:  Pages 2: Changed 0, Empty 0; Tup 56: Vac 0, Keep 0, UnUsed 42.
        Total CPU 0.00s/0.00u sec elapsed 0.00 sec.

Which probably isn't correct, right (the name doesn't seem to match)?

The table's entry is:

NOTICE:  --Relation attributes_table--
NOTICE:  Pages 639: Changed 0, Empty 0; Tup 52846: Vac 0, Keep 0, UnUsed 48.
        Total CPU 0.00s/0.01u sec elapsed 0.01 sec.

Thanks!
Steve
-- 
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-07 16:52:37
Subject: Re: Help tracking down problem with inserts slowing down...
Previous:From: Steve WamplerDate: 2003-12-07 14:28:16
Subject: Re: Help tracking down problem with inserts slowing down...

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