Re: Postmaster processes taking all the CPU

From: "Ericson Smith" <esconsult1(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postmaster processes taking all the CPU
Date: 2007-06-08 20:41:57
Message-ID: 9dd2faa40706081341g65afdda3hf6a5f4c0bfff2f1f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Have you done a full vacuum and not just a reqular vacuum?

- Ericson Smith
Developer
http://www.funadvice.com

On 6/8/07, Andrew Sullivan <ajs(at)crankycanuck(dot)ca> wrote:
> On Fri, Jun 08, 2007 at 03:20:28PM -0500, MC Moisei wrote:
> >
> > pack of postmaster(4-22) processes ran by postgres user are taking
> > over almost all the CPU.
>
> What else is the box doing? If it doesn't have any other work to do,
> why shouldn't postgres use the CPU time? (This is a way of saying,
> "You didn't tell us anything that would allow us to help.")
>
> A
>
> --
> Andrew Sullivan | ajs(at)crankycanuck(dot)ca
> In the future this spectacle of the middle classes shocking the avant-
> garde will probably become the textbook definition of Postmodernism.
> --Brad Holland
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message MC Moisei 2007-06-08 20:58:40 Re: Postmaster processes taking all the CPU
Previous Message Andrew Sullivan 2007-06-08 20:35:40 Re: Postmaster processes taking all the CPU