Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 544BF9FA2EC for ; Wed, 6 Dec 2006 13:47:24 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 62482-09 for ; Wed, 6 Dec 2006 13:47:11 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.182]) by postgresql.org (Postfix) with ESMTP id 2A5A29FA28E for ; Wed, 6 Dec 2006 13:47:12 -0400 (AST) Received: by py-out-1112.google.com with SMTP id d32so153287pye for ; Wed, 06 Dec 2006 09:47:11 -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=HzN9iKvL2sadlmszGZnERD2rWMOmMmUTJLt8SjOxm/j2Q3n/MAqGin0aOOuU8+syvHpPF7fH/VxmxRWGib+xZIk4fpKkSk1GJYLso21dA1LUTBw1/Jwsc/uE6VO1xPFuwPbmXt5PNCDme84UI+xGthdJUCOCxYrf/bW4VaoVXvY= Received: by 10.35.62.1 with SMTP id p1mr1896437pyk.1165427230998; Wed, 06 Dec 2006 09:47:10 -0800 (PST) Received: by 10.35.80.8 with HTTP; Wed, 6 Dec 2006 09:47:10 -0800 (PST) Message-ID: Date: Wed, 6 Dec 2006 23:17:10 +0530 From: "Rajesh Kumar Mallah" To: "asif ali" Subject: Re: VACUUM FULL does not works....... Cc: pgsql-performance@postgresql.org In-Reply-To: <155293.25526.qm@web58414.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline References: <155293.25526.qm@web58414.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/133 X-Sequence-Number: 22189 On 12/6/06, asif ali wrote: > Hi, > I have a "product" table having 350 records. It takes approx 1.8 seconds to > get all records from this table. I copies this table to a "product_temp" > table and run the same query to select all records; and it took 10ms(much > faster). > I did "VACUUM FULL" on "product" table but It did not work. > > I checked the file size of these two tables. > "product" table's file size is "32mb" and > "product_temp" table's file size is "72k". > > So, it seems that "VACUUM FULL" is not doing anything. > Please suggest. It is desirable that PostgreSQL version be reported in problem descriptions. Older versions of pgsql had problem of index bloat. It is interesting to find out why VACUUM FULL does not work in your case(wait for the experts) , but most probably CLUSTERING the table on primary key is going to solve the query performance problem (temporarily) > > asif ali > icrossing inc. > > ________________________________ > Have a burning question? Go to Yahoo! Answers and get answers from real > people who know.