I'm using PostgreSQL ang PHP through Codeigniter framework. I have a problem regarding on how to vacuum the database.
I tried to make this code in Sql manager.
Expand|Select|Wrap|Line Numbers
- VACUUM FULL VERBOSE ANALYZE
=============== ==========
WARNING: skipping "table1" --- only table or database owner can vacuum it
WARNING: skipping "table2" --- only table or database owner can vacuum it
(and so on)....
INFO: free space map contains 44 pages in 13 relations
DETAIL: A total of 224 page slots are in use (including overhead).
224 page slots are required to track all free space.
Current limits are: 204800 page slots, 1000 relations, using 1269 kB.
Query OK, 0 rows affected (46 ms)
=============== ============
In other words, my database doesn't vacuumed.
Do you have any idea and solution?
Is there any function that i can call in codeigniter for this?
Kindly help.
Any suggestion is highly appreciated.
thanks....