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 8C59ED1CCA5 for ; Sat, 27 Mar 2004 00:36:22 +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 51492-06 for ; Fri, 26 Mar 2004 20:36:29 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id 7F2D4D1BA8F for ; Fri, 26 Mar 2004 20:36:20 -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 i2R0aTBq029373; Fri, 26 Mar 2004 19:36:29 -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 "Fri, 26 Mar 2004 19:00:55 -0500" Date: Fri, 26 Mar 2004 19:36:29 -0500 Message-ID: <29372.1080347789@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/394 X-Sequence-Number: 6250 Fabio Esposito writes: >> Did you start from a fresh initdb, or just drop and recreate user >> tables? I'm wondering about index bloat on the system tables ... > I don't think I re initdb it, just dropped. We did try a reindex command > in the interactive editor, with no success. Reindex of what? I'd suggest looking to see the actual sizes of all the indexes on system tables. If my guess is right, some of them may be way out of line (like larger than their associated tables). regards, tom lane