On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano
> 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?
In response to
pgsql-admin by date
|Next:||From: Scott Marlowe||Date: 2008-12-08 15:35:55|
|Subject: Re: Vacuum Problems|
|Previous:||From: Daniel Scott||Date: 2008-12-08 14:36:35|
|Subject: Change user password|