From: | Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> |
---|---|
To: | PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | long vacuum full, gin index and unusually long delete |
Date: | 2008-11-21 10:21:48 |
Message-ID: | 20081121112148.7e465e62@dawn.webthatworks.it |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It does look that on the box I had the gin index problem I'm having
other "strange" behaviours...
VACUUM FULL may take too long and suddenly a delete that took
around 2 min now seems it is never ending even if I just vacuumed
full and restarted the server.
I'm wondering if too high maintenance_work_mem or other cfg may end
up in such problems or a) there is a bug somewhere b) the box is
broken[1] c) some package is broken or can't coexist with some other
d) ?
I've experienced piping scripts through psql, see it die (or at
least disappear from the list of active processes without any log)
and continue to see postgres process eating 100% CPU.
need some advice on how to track down the problem...
This is an etch box with postgresql backported.
[1] even if postgresql is the real weight lifter there, so it is the
one that easier may stumble in some HW problems... for all the other
activities the box seems to behave happily... including some other
heavy weight activities where postgresql is involved.
--
Ivan Sergio Borgonovo
http://www.webthatworks.it
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2008-11-21 11:46:41 | Re: [pgsql-general] cant find postgres executable after initdb |
Previous Message | Marcus Engene | 2008-11-21 10:05:36 | Re: where in (select array) |