Search Postgresql Archives

Re: Postmaster processes taking all the CPU

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I did that remotely, thru the psqladmin. How do I do it from that box ?



> Date: Fri, 8 Jun 2007 16:41:57 -0400
> From: esconsult1@xxxxxxxxx
> Subject: Re: [GENERAL] Postmaster processes taking all the CPU
> CC: pgsql-general@xxxxxxxxxxxxxx
>
> 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx
> > 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/
> >
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux