Re: Index bloat problem?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "David Roussel" <pgsql-performance(at)diroussel(dot)xsmail(dot)com>
Cc: "Bill Chandler" <billybobc1210(at)yahoo(dot)com>, "pgsql-perform" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Index bloat problem?
Date: 2005-04-22 17:28:32
Message-ID: 3033.1114190912@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"David Roussel" <pgsql-performance(at)diroussel(dot)xsmail(dot)com> writes:
> Note there is no reference to iso_pjm_data_update_events_event_id_key
> which is the index that went wacky on us. Does that seem weird to you?

What that says is that that index doesn't belong to that table. You
sure it wasn't a chance coincidence of names that made you think it did?

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Joel Fradkin 2005-04-22 17:51:08 Re: Joel's Performance Issues WAS : Opteron vs Xeon
Previous Message Richard Plotkin 2005-04-22 16:29:39 Re: Disk filling, CPU filling, renegade inserts and deletes?