#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Apr 2012
    Posts
    1
    Rep Power
    0

    Autovacuum question


    I have a postgres 8.x database that appears to be append only. Do I any need to run autovacuum or should I refrain from using it?

    Thanks.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Frequenter (2500 - 2999 posts)

    Join Date
    Oct 2003
    Location
    Germany
    Posts
    2,784
    Rep Power
    348
    First: 8.3 and older are no longer supported.
    8.4 will only be supported until the end of this year. So you should consider upgrading as soon as possible

    9.x has many new features and a lot of performance improvements so it will pay off if you update.

    Now to your original question: you should never disable autovacuum.

    Disabling it has no advantages but keeping it running will have (e.g. your statistics will be updated).

IMN logo majestic logo threadwatch logo seochat tools logo