Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2002
    Posts
    3

    Unanswered: analyze system catalogs?

    vacuum analyze does the system catalogs as well as database tables. is this good, bad or OK?

  2. #2
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Question

    Did the system crah when you run vacuum analyze?

    Then it's ok.

    Did the postgres server run faster?

    Then it's good.

    I don't know if it's good or bad.

    I didn't have any troubles with that.

    But If you use vacuum you schould use sometimes a "FULL" vacuum. Cause this makes the really big cleanup :-)
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  3. #3
    Join Date
    Mar 2002
    Location
    Pilipinas
    Posts
    36

    vacuum

    how often you do vacuum in your server? my current setup is weekly, FULL vacuum.

    eperich, can you give some better way to do this i mean, how often you do vacuum in a week or maybe a simple vacuum will do twice a week. any ideas?

    <-- by the way, our system is used by a certain manufacturing raw materials in/out and some other processes so we expect much entries and deletion of data. -->
    --- Hey! its me!!! the MaleMan ---

  4. #4
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    vacuum

    depends on the database activity
    I have a website with 250.000 hits a day with inserts updates deletes 24 hozurs Live system

    I run vacuum every night at 4 am.

    But there are no strategies
    the only strategy is. Run vacuum at times the database is not heavyliy in use
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  5. #5
    Join Date
    Mar 2002
    Location
    Pilipinas
    Posts
    36

    Post

    i mean vacuum FULL everyday? i sometimes noticed that there are some fixing stuff in the log files... is it safe to run FULL vacuum everyday, or an ordinary vacuum will do.
    --- Hey! its me!!! the MaleMan ---

  6. #6
    Join Date
    Sep 2001
    Location
    Vienna
    Posts
    400

    Like backup strategies

    make It like some backup strategies
    6 days normal vacuum and on the weekend a full vacuum
    I think thats the best way
    http://www.postgresql.org
    --Postgresql is the only kind of thing--

  7. #7
    Join Date
    Mar 2002
    Location
    Pilipinas
    Posts
    36

    Talking THANKs!!!

    thanks for the suggestion!
    --- Hey! its me!!! the MaleMan ---

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •