Connecting Tech Pros Worldwide Help | Site Map

Vacuum

  #1  
Old April 23rd, 2009, 10:24 AM
Newbie
 
Join Date: Apr 2009
Posts: 16
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....
  #2  
Old April 26th, 2009, 12:18 PM
Moderator
 
Join Date: Dec 2006
Location: Europe
Posts: 290

re: Vacuum


And the owner of these tables is?
Reply


Similar Threads
Thread Thread Starter Forum Replies Last Post
Repeated VACUUM reports same number of deleted rows Russell Smith answers 2 November 23rd, 2005 02:23 AM
VACUUM Question Alex answers 6 November 23rd, 2005 01:04 AM
Postgres: VACUUM lnd@hnit.is answers 2 November 22nd, 2005 04:23 AM
VACUUM degrades performance significantly. Database becomes unusable! Stephen answers 10 November 12th, 2005 12:18 AM
Does "vacuum analyze" contain "vacuum"? Holger Marzen answers 6 November 11th, 2005 11:50 PM