X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id C39F811F6D1C for ; Sun, 9 Apr 2006 08:07:32 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: 0.08 X-Spam-Level: X-Spam-Status: No, score=0.08 required=5 tests=[AWL=0.080] Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id LZ9zrDKtZ9cy for ; Sun, 9 Apr 2006 08:07:26 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mx2.ipf.is (scania.ipf.is [85.197.192.147]) by postgresql.org (Postfix) with ESMTP id 1EC0D11F66D2 for ; Sun, 9 Apr 2006 08:07:28 -0300 (ADT) Received: (qmail 3067 invoked by uid 1010); 9 Apr 2006 11:06:48 +0000 Received: from 85.197.216.186 by scania (envelope-from , uid 1008) with qmail-scanner-1.25-st-qms (clamdscan: 0.88/1235. spamassassin: 3.1.1. perlscan: 1.25-st-qms. Clear:RC:1(85.197.216.186):SA:0(-4.3/4.5):. Processed in 0.288507 secs); 09 Apr 2006 11:06:48 -0000 X-Antivirus-IPF-Mail-From: gnari@hive.is via scania X-Antivirus-IPF: 1.25-st-qms (Clear:RC:1(85.197.216.186):SA:0(-4.3/4.5):. Processed in 0.288507 secs Process 3060) Received: from dsl-216-186.hive.is (HELO ?192.168.1.34?) (85.197.216.186) by mx2.ipf.is with SMTP; 9 Apr 2006 11:06:47 +0000 Subject: Re: From: Ragnar To: Doron Baranes Cc: pgsql-performance@postgresql.org In-Reply-To: <0BA77301DFF4B24C9C5DAA74138BF95001E1E7@exchange-1.dbnet.co.il> References: <0BA77301DFF4B24C9C5DAA74138BF95001E1E7@exchange-1.dbnet.co.il> Content-Type: text/plain Date: Sun, 09 Apr 2006 11:10:16 +0000 Message-Id: <1144581016.32289.131.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Archive-Number: 200604/175 X-Sequence-Number: 18259 On sun, 2006-04-09 at 12:47 +0200, Doron Baranes wrote: > Hi > > I am running on postgres 7.4.6 on a pineapp with 512MB RAM. > > I did a database vacuum analyze and rebuild my indexes. If you have previously done a lot of deletes or updates without regular vacuums, you may have to do a VACUUM FULL ANALYZE once to get the table into normal state. After this, regular normal VACUUM ANALYZE should be enough. > When I perform queries on tables of 2M-10M of rows it takes several > minutes and We would need to see the output of EXPLAIN ANALYZE for your query, along with some information about the schema of the tables involved, such as what indexes have been created. Also, let us know about any non-default configuration. gnari