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
