Re[2]: Perfomance decreasing

Hello,

>>> I'm doing vacuum periodically (once a hour), but perfomance
>>> still falls down.

TL> It sounds to me like you may be running into index growth problems.
TL> VACUUM is presently not good about shrinking indexes. If you drop
TL> and recreate the indexes used by your most important queries, does
TL> the performance go back to where it was?

Thanks for solution. After REINDEX command for most significant
tables, perfomance was restored. I will do this procedure every
two days.

I have only one small question. Can I do REINDEX during inserting
of information into tables. Or I must block somehow updating of
tables.

Best regards,
Alexander Loginov mailto:sas(at)mplik(dot)ru