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 A6C76D1ECD7 for ; Mon, 29 Mar 2004 10:57:46 +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 15087-06 for ; Mon, 29 Mar 2004 06:57:49 -0400 (AST) Received: from ideafix.webnow.com.br (unknown [200.155.0.57]) by svr1.postgresql.org (Postfix) with ESMTP id F09E6D1DB5B for ; Mon, 29 Mar 2004 06:57:39 -0400 (AST) Received: by ideafix.webnow.com.br (Postfix, from userid 48) id 7D0B5197550; Mon, 29 Mar 2004 07:57:44 -0300 (BRT) Received: from 200.174.148.100 (SquirrelMail authenticated user marcus.magalhaes@vlinfo.com.br) by webmail.webnow.com.br with HTTP; Mon, 29 Mar 2004 07:57:43 -0300 (BRT) Message-ID: <61715.200.174.148.100.1080557863.squirrel@webmail.webnow.com.br> Date: Mon, 29 Mar 2004 07:57:43 -0300 (BRT) Subject: Re: postgres eating CPU on HP9000 From: "Marcus Andree S. Magalhaes" To: In-Reply-To: <200403281124.43275.josh@agliodbs.com> References: <62945.200.174.148.100.1080383917.squirrel@webmail.webnow.com.br> <200403281124.43275.josh@agliodbs.com> X-Priority: 3 Importance: Normal Cc: , , , X-Mailer: SquirrelMail (version 1.2.11) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/404 X-Sequence-Number: 6260 > Marcus, > >> We are experiencing exactly the same problem here, and we use 7.4 on >> Linux/i386 SMP (2 processors). Our databases does even more access: >> about 30k selects per hour, 10k updates and inserts per hour >> >> Vacuum analyze is done daily. > > What is your max_fsm_pages setting? If you are getting 10,000 > updates per hour, daily VACUUM ANALYZE may not be enough. > max_fsm_pages is set to 500000 > Also do you run VACUUM ANALYZE as a superuser, or as a regular user? > As a regular user (database owner). Is thery any difference when vacuuming as a super user? > -- > Josh Berkus > Aglio Database Solutions > San Francisco > > ---------------------------(end of broadcast)--------------------------- > TIP 9: the planner will ignore your desire to choose an index scan if > your > joining column's datatypes do not match