Re: Vacuum Problems - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Vacuum Problems
Date
Msg-id dcc563d10812080735h42d94633v46449d9933dd22c@mail.gmail.com
Whole thread Raw
In response to Re: Vacuum Problems  ("Rafael Domiciano" <rafael.domiciano@gmail.com>)
Responses Re: Vacuum Problems
List pgsql-admin
On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
<rafael.domiciano@gmail.com> wrote:
> Hello guys,
> I tried to modify my vacuum routine, and started to only run vacuum verbose
> analyze diary followed by a reindex weekly.
> But I still having problems in my database. The uptime database is hard to
> stay below 10.
> I'm thinking that my hardware is not more good as it was sometime ago.
> The machine is a: 2 x Intel Xeon Dual-Core 2.3 GHz, 2 Gb RAM. The load on
> machine is about at 10000 transactions / m
> Maybe I need more RAM memory?

Likely you need more hard drives and / or a quality caching RAID
controller.  What's your I/O subsystem look like now?

pgsql-admin by date:

Previous
From: AmitKumar Jain
Date:
Subject: pg_service.con
Next
From: "Scott Marlowe"
Date:
Subject: Re: Vacuum Problems