X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id C2DE0D6E94 for ; Mon, 21 Nov 2005 15:25:19 -0400 (AST) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01459-04 for ; Mon, 21 Nov 2005 19:25:19 +0000 (GMT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from xproxy.gmail.com (xproxy.gmail.com [66.249.82.195]) by svr1.postgresql.org (Postfix) with ESMTP id E9A53DA4C4 for ; Mon, 21 Nov 2005 15:25:16 -0400 (AST) Received: by xproxy.gmail.com with SMTP id h28so1513474wxd for ; Mon, 21 Nov 2005 11:25:15 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=HLyb5UnFs0w9FG9FTYUFWxQZ4/8JvJ1Fwb4wbFD0IQ2mDBbJn1NF5BOEfloFCuJlg91+DN9bicMK3mJiqddvmPj6y8Mu9OF6n0K9ElzIsKrTErV94T7fvuuqzlrQGXz0YY0Y4cJRFtFdVpVe/111wwEL/IQBnluHbERyfFBgZoA= Received: by 10.65.206.12 with SMTP id i12mr3126628qbq; Mon, 21 Nov 2005 08:51:55 -0800 (PST) Received: by 10.65.180.2 with HTTP; Mon, 21 Nov 2005 08:51:54 -0800 (PST) Message-ID: Date: Mon, 21 Nov 2005 11:51:54 -0500 From: Jaime Casanova To: Nirmal Kumar Subject: Re: Postgres Database slow Cc: pgsql-admin@postgresql.org In-Reply-To: <20051121150429.51451.qmail@web53508.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <20051121150429.51451.qmail@web53508.mail.yahoo.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.532 required=5 tests=[AWL=0.256, MAILTO_TO_SPAM_ADDR=0.276] X-Spam-Score: 0.532 X-Spam-Level: X-Archive-Number: 200511/286 X-Sequence-Number: 19659 On 11/21/05, Nirmal Kumar wrote: > Hi > > We are facing a slowness problem in posgres Database. > Whenver we query a data it is very very slow.It is > running on the IBM ISERIES I5 Server. > > HARDWARE: IBM Iseries I5 PPC Server > OS: SUSE LINUX ENTERPRISE SERVER 9.0 > POSTGRESSQL: 7.4.2 > WEB SERVER: APACHE2 > > Using the command line also it is taking long time to > query a database. > > Any Cluses > > Regards > Nirmal > > > how many memory do you have? can you show an explain of some query that is slow? had you run VACUUM ANALYZE (or ANALYZE at least) recently? it's all the system that slow or just queries? (maybe it is a problem of lack of resources) -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)