Postgres Pro
Downloads
Home   >   mailing lists

Re: Index bloat problem? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Index bloat problem?
Date
Msg-id 329.1114178793@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index bloat problem?  (David Roussel <pgsql-performance@diroussel.xsmail.com>)
Responses Re: Index bloat problem?  ("David Roussel" <pgsql-performance@diroussel.xsmail.com>)
List pgsql-performance
Tree view 
David Roussel <pgsql-performance@diroussel.xsmail.com> writes:
> |dave_data_update_events                r       1593600.0 40209
> |dave_data_update_events_event_id_key   i       1912320.0 29271

Hmm ... what PG version is this, and what does VACUUM VERBOSE on
that table show?

            regards, tom lane

pgsql-performance by date:

Previous
From: Jeff
Date:
Subject: Re: two queries and dual cpu (perplexed)
Next
From: "David Roussel"
Date:
Subject: Re: Index bloat problem?