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
