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.
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 |