Message-ID: <46D2C906.5030403@rentalia.com>
Date: Mon, 27 Aug 2007 14:52:22 +0200
From: ruben@rentalia.com
Reply-To: ruben@rentalia.com
User-Agent: Thunderbird 1.5.0.12 (X11/20070604)
MIME-Version: 1.0
To: Chris Mair <chris@1006.org>
CC: pgsql-performance@postgresql.org
Subject: Re: Postgres performance problem
References: <46D2B879.6010308@rentalia.com> <46D2C4AF.8090501@1006.org>
In-Reply-To: <46D2C4AF.8090501@1006.org>
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit


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 ll be pleased to tell it here ...


Chris Mair escribió:
>> 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 poor with the time.
>>
>> Im not able to find the problem, seems there is not slow querys ( I have
>> log_min_duration_statement = 5000 right now, tomorrow I ll decrease it )
>>
>> Server is HP, and seems there is not hardware problems detected.
>>
>> Any ideas to debug it?
> 
> Hi,
> 
> first of all: let us know the exact version of PG and the OS.
> 
> If performance is getting worse, there ususally is some bloat
> envolved. Not vacuuming aggressivly enough, might be the most
> common cause. Do you autovacuum or vacuum manually?
> Tell us more...
> 
> 
> Bye,
> Chris.
> 
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
> 
>               http://www.postgresql.org/docs/faq
> 
>