| From: | A B <gentosaker(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Runaway postgres process? |
| Date: | 2009-01-30 15:02:01 |
| Message-ID: | dbbf25900901300702y34e05c87t4a8bd7b2e5e2ad26@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Well, it stoped. And in the log I can see:
LOGG: statement: UPDATE VList SET updated=true WHERE id=985
LOGG: duration: 1129993.209 ms
and a few lines below
(with queries in between)
LOGG: statement: UPDATE VList SET updated=false WHERE id=985
LOGG: duration: 0.400 ms
So, something was blocking the query, seriously!
Still interested in findingout how to detect what is going on.
There were other processes, could it be a lock? I have not specified
any special transaction or so. I was calling from a PHP script (I
think).
2009/1/30 A B <gentosaker(at)gmail(dot)com>:
> Hi.
> I just discovered three "postmaster" processes running and really
> eating all the cpu.
> I'm not sure why?
> So, what steps do I take for finiding the queries that is causing this?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | A B | 2009-01-30 15:05:58 | Re: Runaway postgres process? |
| Previous Message | A B | 2009-01-30 14:52:44 | Runaway postgres process? |