Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 1DD279FB1F9 for ; Mon, 25 Sep 2006 13:25:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 23799-10 for ; Mon, 25 Sep 2006 16:25:41 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey- Received: from exchange.g2switchworks.com (mail.g2switchworks.com [63.87.162.25]) by postgresql.org (Postfix) with ESMTP id 6D92E9FB1D7 for ; Mon, 25 Sep 2006 13:25:39 -0300 (ADT) Received: from 10.10.1.37 ([10.10.1.37]) by exchange.g2switchworks.com ([10.10.1.2]) with Microsoft Exchange Server HTTP-DAV ; Mon, 25 Sep 2006 16:25:37 +0000 Received: from state.g2switchworks.com by mail.g2switchworks.com; 25 Sep 2006 11:25:37 -0500 Subject: Re: postgrses database problem From: Scott Marlowe To: Srinivas Lakshmi Sistla Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1159201537.26848.17.camel@state.g2switchworks.com> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 (1.4.6-2) Date: Mon, 25 Sep 2006 11:25:37 -0500 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=SPF_PASS, UNPARSEABLE_RELAY X-Spam-Level: X-Archive-Number: 200609/267 X-Sequence-Number: 23181 On Mon, 2006-09-25 at 10:41, Srinivas Lakshmi Sistla wrote: > Guys, > > I am new to Postgresql. We have a database on Linux box and users > complaining about queries running very slow. I tried to run vacuum > this moring but it doesn't seem to do anything. I logged on to > database by typing psql bhpbprod (bhpbprod is database name) and that > gave me the prompt bhpbprod=# . There i typed in vacuum analyze and i > got the same prompt again. so i assume it didn't work. > > So could some one please help how to go about this problem. I really > appreciate all your positive replys. Thanks. You probably just need a ; character vacuum analyze; or you can enter it on the second line: vacuum analyze ; and it'll still work.