Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id 8CE7C9F93E2
	for <pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  6 Dec 2006 13:07:12 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024)
	with ESMTP id 65084-04 for
	<pgsql-performance-postgresql.org@postgresql.org>;
	Wed,  6 Dec 2006 13:07:03 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4
Received: from web58414.mail.re3.yahoo.com (web58414.mail.re3.yahoo.com
	[68.142.236.182])
	by postgresql.org (Postfix) with SMTP id 95A279F9F0E
	for <pgsql-performance@postgresql.org>;
	Wed,  6 Dec 2006 13:07:04 -0400 (AST)
Received: (qmail 25573 invoked by uid 60001); 6 Dec 2006 17:07:03 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com;
	h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID;
	b=oBWnA1fG/SjhW/I0GmWqCIae4QfIejCcXMz7P7xmPZ2UK83/f3NkQCfhE8q1/M0A3ygUFnNqYeir5qU33axlwUljBu0JZhaU0wvZnVrh9puK7zIPDZm4QKjnLrKK1nolLFuITlezoBPfu2gUkw5aYF+VdYaaDpfv7SFDQZXOMfw=;
X-YMail-OSG: 
 rLAGXYMVM1kCFtjs1ZAxAxxrX8pnQKJgdDJWc6K4lzoeVMkusGGkXnbCfj9TZfZn28wFRN5L_2Nr.ZIENO8sRO8p8teFDpFiRsixhB6imEbgeydSBG52hSiWd4s2dFfqyAPaYGSOmBRIQSg-
Received: from [65.218.233.130] by web58414.mail.re3.yahoo.com via HTTP;
	Wed, 06 Dec 2006 09:07:03 PST
Date: Wed, 6 Dec 2006 09:07:03 -0800 (PST)
From: asif ali <asif_icrossing@yahoo.com>
Subject: VACUUM FULL does not works.......
To: pgsql-performance@postgresql.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-716178976-1165424823=:25526"
Content-Transfer-Encoding: 8bit
Message-ID: <155293.25526.qm@web58414.mail.re3.yahoo.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.587 tagged_above=0 required=5 tests=AWL, BAYES_50,
	DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_MESSAGE
X-Spam-Level: *
X-Archive-Number: 200612/128
X-Sequence-Number: 22184

--0-716178976-1165424823=:25526
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

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.
  
  asif ali
  icrossing inc.
 
---------------------------------
Have a burning question? Go to Yahoo! Answers and get answers from real people who know.
--0-716178976-1165424823=:25526
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit

Hi,<br>  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).<br>  I did "VACUUM FULL" on "product" table but It did not work.<br>  <br>  I checked the file size of these two tables.&nbsp; <br>  "product" table's file size is "32mb" and<br>  "product_temp" table's file size is "72k".<br>  <br>  So, it seems that "VACUUM FULL" is not doing anything. <br>  Please suggest.<br>  <br>  asif ali<br>  icrossing inc.<p>&#32;

<hr size=1>Have a burning question? Go to <a href="http://answers.yahoo.com/;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx">Yahoo! Answers</a> and get answers from real people who know.
--0-716178976-1165424823=:25526--