Vacuum

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • lion cave
    New Member
    • Apr 2009
    • 23

    #1

    Vacuum

    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.
    Code:
    VACUUM FULL VERBOSE ANALYZE
    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....
  • rski
    Recognized Expert Contributor
    • Dec 2006
    • 700

    #2
    And the owner of these tables is?

    Comment

    Working...