Re: [PERFORM] Postgres performance problem

Bill Moran escribió: > In response to Chris Mair <[EMAIL PROTECTED]>: > >>> Hi, >>> >>> Note: I have already vacumm full. It does not solve the problem. > > To jump in here in Chris' defense, regular vacuum is not at all the same > as vacuum full. Periodic vacuum is _much_ preferable to an occas

Re: [PERFORM] Postgres performance problem

Just a random thought/question... Are you running else on the machine? When you say "resource usage", do you mean hd space, memory, processor, ??? What are your values in top? More info... Cheers Anton On 27/08/2007, Bill Moran <[EMAIL PROTECTED]> wrote: > In response to Chris Mair <[EMAIL PROTEC

Re: [PERFORM] Postgres performance problem

In response to Chris Mair <[EMAIL PROTECTED]>: > > Hi, > > > > Note: I have already vacumm full. It does not solve the problem. To jump in here in Chris' defense, regular vacuum is not at all the same as vacuum full. Periodic vacuum is _much_ preferable to an occasional vacuum full. The output

Re: [PERFORM] Postgres performance problem

SO: CentOS release 4.3 (Final) (kernel: 2.6.9-34.0.1.ELsmp) Postgres: 8.1.3 I had some problems before with autovacuum. So, Each day I crontab execute: vacuumdb -f -v --analyze reindex database vacadb I saw logs (the output of vacuum and reindex) and there is no errors. If u need more info, I

Re: [PERFORM] Postgres performance problem

Hi, Note: I have already vacumm full. It does not solve the problem. I have a postgres 8.1 database. In the last days I have half traffic than 4 weeks ago, and resources usage is twice. The resource monitor graphs also shows hight peaks (usually there is not peaks) The performarce is getting po

[PERFORM] Postgres performance problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, Note: I have already vacumm full. It does not solve the problem. I have a postgres 8.1 database. In the last days I have half traffic than 4 weeks ago, and resources usage is twice. The resource monitor graphs also shows hight peaks (usually th