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 A7B45DA9A8 for ; Mon, 21 Nov 2005 21:37:13 -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 40059-02 for ; Tue, 22 Nov 2005 01:37:16 +0000 (GMT) X-Greylist: delayed 03:19:57.560731 by SQLgrey- Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id F1D73DA1B6 for ; Mon, 21 Nov 2005 21:37:10 -0400 (AST) Received: from mail.libertyrms.com (unknown [207.219.45.62]) by svr2.postgresql.org (Postfix) with ESMTP id 07EFFF114D for ; Mon, 21 Nov 2005 19:10:09 +0000 (GMT) Received: from dba5.int.libertyrms.com ([10.1.3.44]) by mail.libertyrms.com with esmtp (Exim 4.22) id 1EeH3G-0004Qt-4Q for pgsql-admin@postgresql.org; Mon, 21 Nov 2005 14:10:06 -0500 Message-ID: <43821B8E.1060109@ca.afilias.info> Date: Mon, 21 Nov 2005 14:10:06 -0500 From: Brad Nicholson User-Agent: Mozilla Thunderbird 0.8 (X11/20040913) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Postgres Database slow References: <20051121150429.51451.qmail@web53508.mail.yahoo.com> In-Reply-To: <20051121150429.51451.qmail@web53508.mail.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: bnichols@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200511/295 X-Sequence-Number: 19668 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 > > > Nope, because you haven't given anything for us to work with. It could the database configuration. It could be the hardware. It could be poorly written queries. It could be that you aren't vacuuming the database often enough, ect, ect. A good place to start looking would be to use the explain command to look at the query plans for some of your queries. Post some to the list if you need a hand. -- Brad Nicholson 416-673-4106 Database Administrator, Afilias Canada Corp.