Re: How to monitor resources on Linux.

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to monitor resources on Linux.
Date: 2007-08-28 20:36:50
Message-ID: 20070828203650.GC1983@phlogiston.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Aug 28, 2007 at 03:24:43PM -0500, Scott Marlowe wrote:
> Also, by 7.4 autovacuum existed, even if it isn't perfect yet. It's
> still better than weekly analyze.

I wouldn't use it -- it had serious issues. But this is another
point: 7.4 has a big whack of performance issues compared to later
releases. So if upgrading is at all an option, it's worth
considering. (This is all unrelated to memory use, though.)

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
However important originality may be in some fields, restraint and
adherence to procedure emerge as the more significant virtues in a
great many others. --Alain de Botton

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message John R Allgood 2007-08-28 20:46:46 Re: How to monitor resources on Linux.
Previous Message Tom Lane 2007-08-28 20:32:39 Re: pg_dump object dump-order