From: | ruben(at)rentalia(dot)com |
---|---|
To: | Chris Mair <chris(at)1006(dot)org> |
Cc: | pgsql-performance(at)postgresql(dot)org |
Subject: | Re: Postgres performance problem |
Date: | 2007-08-27 12:52:22 |
Message-ID: | 46D2C906.5030403@rentalia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tomas Tamosaitis | 2007-08-27 12:57:29 | Re: partitioned table and ORDER BY indexed_field DESC LIMIT 1 |
Previous Message | Chris Mair | 2007-08-27 12:33:51 | Re: Postgres performance problem |