2006/12/6, asif ali <asif_icrossing@xxxxxxxxx>:
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.
try VACUUM FULL VERBOSE and report the result. -- Jean-Max Reymond CKR Solutions Open Source Nice France http://www.ckr-solutions.com
