increased load on server

From: jf <jfmeteo(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: increased load on server
Date: 2011-02-11 19:53:43
Message-ID: AANLkTi=rYsHh4nJJPJ283WRa92BbhfsUzn03RM_PeYoE@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,

I'm using postgreSQL 8.3 on Ubuntu 8.04 with ltree.
I tried to tune posgresql.conf to use more memory.

In two years on production everything was fine, but today something
goes wrong: postgresql processes eat my server ressources, my load,
which was between 0 and 2.5 on my 4 cpus server, grows to 20.

When the trouble appends there was a lot of waiting queries on my ltree table.
I tried to restart postgresql server and to reboot the server, but 5
minutes later, the trouble was here again.

I did a backup/restore of my database (pg_dump -Fc / pg_restore), and
it was fine for 2 hours but after the touble reappears.

I notice that the "base" directory grows a lot when the trouble
begins. I made a 'vacuum', 'vacuum analyze', 'vacuum full' but the
disk usage isn't lower.

Please have you a clue to help me ? This is the week-end and I'm
hoping to fix this before monday.

Thanks.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2011-02-11 22:32:10 Re: increased load on server
Previous Message Selva manickaraja 2011-02-11 17:43:35 Re: Cascading Recovery