Thread: postgres eating CPU
Hi, in March there was an interesting discussion on the list with the subject "postgres eating CPU on HP9000". Now I'm the same problem on a Dell dual processor machine. Anybody know if there was a solution? Thanks Piergiorgio
> in March there was an interesting discussion on the list with the > subject "postgres eating CPU on HP9000". Link, please? -- --Josh Josh Berkus Aglio Database Solutions San Francisco
Josh Berkus wrote: >>in March there was an interesting discussion on the list with the >>subject "postgres eating CPU on HP9000". >> >> > >Link, please? > > > http://archives.postgresql.org/pgsql-performance/2004-03/msg00380.php
> >>in March there was an interesting discussion on the list with the > >>subject "postgres eating CPU on HP9000". Aha, this one. Yeah, I believe that they upgraded to 7.4 inorder to deal with REINDEX issues. -- --Josh Josh Berkus Aglio Database Solutions San Francisco
"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
Josh Berkus wrote: >>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 -- Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC Postgresql support, programming shared hosting and dedicated hosting. +1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL