I'm setting up a website and am considering PostgreSQL for the DB. But I really just want to set it up and forget about it. How likely is this "set and forget" mindset for PostgreSQL? If it's not realistic, what kind of maintenance tasks should I expect to be carrying out?
edit: I found useful info here: http://www.postgresql.org/docs/9.1/static/maintenance.html