On Mon, Dec 8, 2008 at 6:04 AM, Rafael Domiciano <rafael.domiciano@xxxxxxxxx> 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? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin