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@mplik.ru