Re: VACUUM FULL does not works....... - Mailing list pgsql-performance

Thanks for the prompt reply...
Here is the output of "VACUUM FULL VERBOSE"
The postgres version is "8.0.3".

Thanks
asif ali
icrossing inc

INFO:  vacuuming "public.product_table"
INFO:  "product_table": found 0 removable, 139178 nonremovable row versions in 4305 pages
DETAIL:  138859 dead row versions cannot be removed yet.
Nonremovable row versions range from 152 to 273 bytes long.
There were 26916 unused item pointers.
Total free space (including removable row versions) is 4507788 bytes.
249 pages are or will become empty, including 0 at the end of the table.
746 pages containing 4286656 free bytes are potential move destinations.
CPU 0.04s/0.06u sec elapsed 0.15 sec.
INFO:  index "product_table_client_name_unique" now contains 139178 row versions in 3916 pages
DETAIL:  0 index row versions were removed.
2539 index pages have been deleted, 2055 are currently reusable.
CPU 0.08s/0.02u sec elapsed 0.76 sec.
INFO:  index "product_table_cpc_agent_id_unique" now contains 139178 row versions in 1980 pages
DETAIL:  0 index row versions were removed.
1162 index pages have been deleted, 950 are currently reusable.
CPU 0.04s/0.02u sec elapsed 0.49 sec.
INFO:  index "product_table_pk" now contains 139178 row versions in 3472 pages
DETAIL:  0 index row versions were removed.
2260 index pages have been deleted, 1870 are currently reusable.
CPU 0.08s/0.02u sec elapsed 0.53 sec.
INFO:  "product_table": moved 18631 row versions, truncated 4305 to 4299 pages
DETAIL:  CPU 0.18s/1.14u sec elapsed 2.38 sec.
INFO:  index "product_table_client_name_unique" now contains 157728 row versions in 3916 pages
DETAIL:  81 index row versions were removed.
2407 index pages have been deleted, 1923 are currently reusable.
CPU 0.04s/0.01u sec elapsed 0.17 sec.
INFO:  index "product_table_cpc_agent_id_unique" now contains 157728 row versions in 1980 pages
DETAIL:  81 index row versions were removed.
1100 index pages have been deleted, 888 are currently reusable.
CPU 0.03s/0.01u sec elapsed 0.16 sec.
INFO:  index "product_table_pk" now contains 157728 row versions in 3472 pages
DETAIL:  81 index row versions were removed.
2150 index pages have been deleted, 1760 are currently reusable.
CPU 0.05s/0.01u sec elapsed 0.30 sec.
INFO:  vacuuming "pg_toast.pg_toast_11891545"
INFO:  "pg_toast_11891545": found 0 removable, 0 nonremovable row versions in 0 pages
DETAIL:  0 dead row versions cannot be removed yet.
Nonremovable row versions range from 0 to 0 bytes long.
There were 0 unused item pointers.
Total free space (including removable row versions) is 0 bytes.
0 pages are or will become empty, including 0 at the end of the table.
0 pages containing 0 free bytes are potential move destinations.
CPU 0.00s/0.00u sec elapsed 0.00 sec.
INFO:  index "pg_toast_11891545_index" now contains 0 row versions in 1 pages
DETAIL:  0 index pages have been deleted, 0 are currently reusable.
CPU 0.00s/0.00u sec elapsed 0.00 sec.

Query returned successfully with no result in 5201 ms.

Jean-Max Reymond <jmreymond@gmail.com> wrote:

2006/12/6, asif ali :
> 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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

---

Want to start your own business? Learn how on Yahoo! Small Business.