Skip site navigation (1) Skip section navigation (2)

Re: postgres eating CPU

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "silviapg(at)tiscali(dot)it" <silviapg(at)tiscali(dot)it>
Cc: pgsql-performance(at)postgresql(dot)org, josh(at)agliodbs(dot)com
Subject: Re: postgres eating CPU
Date: 2004-11-17 23:38:40
Message-ID: 5433.1100734720@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-performance
"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".
>    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

In response to

pgsql-performance by date

Next:From: Jim C. NasbyDate: 2004-11-18 00:20:09
Subject: Re: Analyzer is clueless
Previous:From: Josh BerkusDate: 2004-11-17 23:23:41
Subject: Re: postgres eating CPU

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group