Re: postgres eating CPU - Mailing list pgsql-performance

From Tom Lane
Subject Re: postgres eating CPU
Date
Msg-id 5433.1100734720@sss.pgh.pa.us
Whole thread Raw
In response to Re: postgres eating CPU  ("silviapg@tiscali.it" <silviapg@tiscali.it>)
List pgsql-performance
"silviapg@tiscali.it" <silviapg@tiscali.it> writes:
> in March there was an interesting discussion on the list with the
> subject "postgres eating CPU on HP9000".
>    http://archives.postgresql.org/pgsql-performance/2004-03/msg00380.php

Reviewing that, the problem is most likely that (a) they didn't have
max_fsm_pages set high enough to cover the database, and (b) they were
running 7.3.* which is prone to index bloat.

            regards, tom lane

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: postgres eating CPU
Next
From: "Jim C. Nasby"
Date:
Subject: Re: Analyzer is clueless