in reply to Make sure you're solving the right problem

This is why big database applications need DBAs. And why you should be using autovacuum if you are running PostgreSQL versions prior to 8.1 (when the autovacuum features were added to the server, instead of being an external process).

We're not surrounded, we're in a target-rich environment!
  • Comment on Re: Make sure you're solving the right problem

Replies are listed 'Best First'.
Re^2: Make sure you're solving the right problem
by talexb (Chancellor) on Oct 13, 2006 at 17:07 UTC
      This is why big database applications need DBAs.

    Granted. However, in small companies, one person gets to do many things: I've assumed the System Architect job, I'm the only Software Developer and Software Support person, and I also pretend to be the DBA.

    Right now I'm doing a daily VACUUM on the application database, and a weekly VACUUM on the whole database. Due to the success of ANALYZE, I will likely be doing that daily as well.

    Upgrading the database version is on my list -- the development system I have uses the fairly recent 8.0.3, but the Production system is .. ahem .. older than that.

    Alex / talexb / Toronto

    "Groklaw is the open-source mentality applied to legal research" ~ Linus Torvalds

[reply]
[d/l]
[select]

In Section Meditations