By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,327 Members | 2,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,327 IT Pros & Developers. It's quick & easy.

Vacuum

P: 23
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....
Apr 23 '09 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 700
And the owner of these tables is?
Apr 26 '09 #2

Post your reply

Sign in to post your reply or Sign up for a free account.