Re: [GENERAL] Re: Perfomance decreasing

2001-08-20 Thread Denis Perchine
On Friday 17 August 2001 15:09, Ivan Babikov wrote: > > In this case, however, I think he may be understating too much. I read > > the original question as "PostgreSQL is not useful for production systems." > Call me melodramatic if you like: you are probably right. > > > The point, I guess, is t

Re: [GENERAL] Re: Perfomance decreasing

2001-08-20 Thread Einar Karttunen
On Fri, Aug 17, 2001 at 02:09:33PM +0600, Ivan Babikov wrote: > > > In this case, however, I think he may be understating too much. I read > the original question as "PostgreSQL is not useful for production systems." > Call me melodramatic if you like: you are probably right. > > > > The point,

[GENERAL] Re: Perfomance decreasing

2001-08-14 Thread Allan Engelhardt
Tom Lane wrote: > >> I'm doing vacuum periodically (once a hour), but perfomance > >> still falls down. > > It sounds to me like you may be running into index growth problems. > VACUUM is presently not good about shrinking indexes. I always enjoy Tom's comments - he is the master of understa