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

Re: Index bloat problem?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bill Chandler <billybobc1210(at)yahoo(dot)com>
Cc: pgsql-perform <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index bloat problem?
Date: 2005-04-22 05:57:11
Message-ID: 27013.1114149431@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
Bill Chandler <billybobc1210(at)yahoo(dot)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

In response to

Responses

pgsql-performance by date

Next:From: Dave PageDate: 2005-04-22 08:08:01
Subject: Re: Joel's Performance Issues WAS : Opteron vs Xeon
Previous:From: Gavin SherryDate: 2005-04-22 03:57:17
Subject: Re: two queries and dual cpu (perplexed)

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