| 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: | Whole Thread | Raw Message | 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 |