Connecting Tech Pros Worldwide Forums | Help | Site Map

Vacuum

Newbie
 
Join Date: Apr 2009
Posts: 16
#1: Apr 23 '09
Hi,

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
  1. VACUUM FULL VERBOSE ANALYZE
  2.  
It would message like this...
=========================
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....

Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 293
#2: Apr 26 '09

re: Vacuum


And the owner of these tables is?
Reply