Re: Posrgres speed problem - solved?

Guido Neitzer wrote:

> On 13.06.2006, at 8:44 Uhr, Ruben Rubio Rey wrote:
>
>> Tonight database has been vacumm full and reindex (all nights
>> database do it)
>>
>> Now its working fine. Speed is as spected. I ll be watching that  sql
>> ...
>> Maybe the problem exists when database is busy, or maybe its  solved ...
>
>
> Depending on the usage pattern the nightly re-index / vacuum analyse
> is suboptimal. If you have high insert/update traffic your
> performance will decrease over the day and will only be good in the
> morning hours and I hope this is not what you intend to have.
>
> Autovacuum is the way to go, if you have "changing content". Perhaps
> combined with vacuum analyse in a nightly or weekly schedule. We do
> this weekly.
>
> cug
>
>
I ll configure autovacum. I ll write if problem is solved.