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.
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