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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
