| From: | Chris Mair <chris(at)1006(dot)org> |
|---|---|
| To: | Ruben Rubio <ruben(at)rentalia(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Postgres performance problem |
| Date: | 2007-08-27 12:33:51 |
| Message-ID: | 46D2C4AF.8090501@1006.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ruben | 2007-08-27 12:52:22 | Re: Postgres performance problem |
| Previous Message | Willo van der Merwe | 2007-08-27 12:16:48 | Performance issue |