From: Tom Lane <tgl@sss.pgh.pa.us>
To: Bill Chandler <billybobc1210@yahoo.com>
Cc: pgsql-perform <pgsql-performance@postgresql.org>
Subject: Re: Index bloat problem?
Date: Fri, 22 Apr 2005 01:57:11 -0400
Message-ID: <27013.1114149431@sss.pgh.pa.us> (raw)
In-Reply-To: <20050421170018.2998.qmail@web51403.mail.yahoo.com>
References: <20050421170018.2998.qmail@web51403.mail.yahoo.com>
Bill Chandler <billybobc1210@yahoo.com> writes:
> Client is reporting that the size of an index is
> greater than the number of rows in the table (1.9
> million vs. 1.5 million).
This thread seems to have wandered away without asking the critical
question "what did you mean by that?"
It's not possible for an index to have more rows than there are in
the table unless something is seriously broken. And there aren't
any SQL operations that let you inspect an index directly anyway.
So: what is the actual observation that led you to the above
conclusion? Facts, please, not inferences.
regards, tom lane
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: tgl@sss.pgh.pa.us, billybobc1210@yahoo.com
Subject: Re: Index bloat problem?
In-Reply-To: <27013.1114149431@sss.pgh.pa.us>
* 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