| From: | "Michael Swierczek" <mike(dot)swierczek(at)gmail(dot)com> |
|---|---|
| To: | ccannick <ccannick(at)gmail(dot)com> |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Re: Runaway Instances of Postmaster |
| Date: | 2007-03-09 01:03:10 |
| Message-ID: | 68b5b5880703081703s75848c13l480f8414fdeb9056@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
On 5 Mar 2007 08:50:49 -0800, ccannick <ccannick(at)gmail(dot)com> wrote:
> I'm running v8.0 on Linux and am seeing the following phenomenon:
>
> With each connection, I get more and more postmasters running that
> never complete, die, or timeout. Eventually all of my memory is
> depleted and the system is severely hampered.
I could be wrong, but I believe you need exclusive access to the
database in order to perform a full vacuum. If someone was
attempting a full vacuum while other connections to the database were
active, that might explain your problem.
I'm guessing that's unlikely, but I thought I would mention the possibility.
-Mike
| From | Date | Subject | |
|---|---|---|---|
| Next Message | joseph speigle | 2007-03-09 01:06:12 | Re: Help with creating Documentation |
| Previous Message | Lukas | 2007-03-08 20:02:07 | Pg_dump and bytaA |