Re: postgresql performance tuning

Vivek Khera wrote:
>
> On Dec 6, 2005, at 11:14 AM, Ameet Kini wrote:
>
>> need for vacuums. However, it'd be great if there was a similar
>> automatic
>> reindex utility, like say, a pg_autoreindex daemon. Are there any plans
>> for this feature?  If not, then would cron scripts be the next best
>
> what evidence do you have that you are suffering index bloat?  or are
> you just looking for solutions to problems that don't exist as an
> academic exercise? :-)

The files for the two indices on a single table used 7.8GB of space
before a reindex, and 4.4GB after.   The table had been reindexed over
the weekend and a vacuum was completed on the table about 2 hours ago.

The two indices are now 3.4GB smaller.   I don't think this counts as
bloat, because of our use case.  Even so, we reindex our whole database
every weekend.

-- Alan