Re: BUG #5990: 100% CPU reached - Mailing list pgsql-bugs

From Stephen Frost
Subject Re: BUG #5990: 100% CPU reached
Date
Msg-id 20110421013408.GB4548@tamriel.snowman.net
Whole thread Raw
In response to Re: BUG #5990: 100% CPU reached  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-bugs
* Kevin Grittner (Kevin.Grittner@wicourts.gov) wrote:
> > Could you please provide us some support regarding this issue?
[...]
> Please read this and post to the pgsql-performance list:
>=20=20
> http://wiki.postgresql.org/wiki/SlowQueryQuestions

If that looks like a lot of complication/effort, let's at least start
with including what the hardware is (how much memory, how many CPUs,
what disk configuration, etc) and your postgresql.conf.  The defaults
for postgresql.conf are almost always wrong for a given hardware (unless
you're running on a Celeron w/ 1G of RAM...).

    Thanks,

        Stephen

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #5988: CTINE duplicates constraints
Next
From: "Rakshit"
Date:
Subject: BUG #5992: The database cluster initialisation failed