X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E03DFD1ED06 for ; Fri, 26 Mar 2004 21:53:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 89605-01 for ; Fri, 26 Mar 2004 17:53:40 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id EF506D1ED21 for ; Fri, 26 Mar 2004 17:53:32 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2QLrenm027628; Fri, 26 Mar 2004 16:53:40 -0500 (EST) To: Fabio Esposito Cc: pgsql-performance@postgresql.org Subject: Re: postgres eating CPU on HP9000 In-reply-to: References: Comments: In-reply-to Fabio Esposito message dated "Tue, 23 Mar 2004 14:21:34 -0500" Date: Fri, 26 Mar 2004 16:53:40 -0500 Message-ID: <27627.1080338020@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/397 X-Sequence-Number: 6253 Fabio Esposito writes: > We've recently integrated postgres into an existing mature app. Its a > time sensitive 24x7 system. It runs on HP9000, a K370 Dual Processor > system. Postgres is version 7.3.2. Its spawned as a child from a parent > supervisory process, and they communicate to eachother via shared memory. You would be well advised to update to 7.3.6, though I'm not sure if any of the post-7.3.2 fixes have anything to do with your speed problem. > Recently it started eating up the cpu, and cannot keepup with the system > like it used to. The interesting thing here is that it still runs great > on an older system with less ram, one slower cpu, and an older disk. > We tried the following with no success: > running VACCUUM FULL > dropping all tables and staring anew Did you start from a fresh initdb, or just drop and recreate user tables? I'm wondering about index bloat on the system tables ... regards, tom lane