pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Steve Wampler <swampler@noao.edu>
To: Steve Wampler <swampler@noao.edu>
Cc: Robert Treat <xzilla@users.sourceforge.net>
Cc: Postgres-performance <pgsql-performance@postgresql.org>
Subject: Re: Help tracking down problem with inserts slowing down...
Date: Sun, 7 Dec 2003 07:52:35 -0700
Message-ID: <20031207145235.GA8734@weaver.tuc.noao.edu> (raw)
In-Reply-To: <20031207142816.GA8321@weaver.tuc.noao.edu>
References: <1070661108.20063.86.camel@weaver.tuc.noao.edu>
	<200312052154.52223.xzilla@users.sourceforge.net>
	<20031207142816.GA8321@weaver.tuc.noao.edu>

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@noao.edu
The gods that smiled on your birth are now laughing out loud.



view thread (9+ messages)  latest in thread

Message-ID: <20031207145235.GA8734@weaver.tuc.noao.edu>
Permalink:  ../20031207145235.GA8734@weaver.tuc.noao.edu/
Also on:    postgresql.org/message-id/20031207145235.GA8734@weaver.tuc.noao.edu

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: swampler@noao.edu, xzilla@users.sourceforge.net
  Subject: Re: Help tracking down problem with inserts slowing down...
  In-Reply-To: <20031207145235.GA8734@weaver.tuc.noao.edu>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox