"silviapg(at)tiscali(dot)it" <silviapg(at)tiscali(dot)it> writes:
> in March there was an interesting discussion on the list with the
> subject "postgres eating CPU on HP9000".
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
In response to
pgsql-performance by date
|Next:||From: Jim C. Nasby||Date: 2004-11-18 00:20:09|
|Subject: Re: Analyzer is clueless|
|Previous:||From: Josh Berkus||Date: 2004-11-17 23:23:41|
|Subject: Re: postgres eating CPU|