Re: Autovacuum is running forever

From: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
To: "Sachchida Ojha" <sojha(at)secure-elements(dot)com>
Cc: "Michael Glaesemann" <grzm(at)seespotcode(dot)net>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Autovacuum is running forever
Date: 2007-08-21 22:19:59
Message-ID: dcc563d10708211519q7bd741b2g5912f3bdf298e908@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 8/21/07, Sachchida Ojha <sojha(at)secure-elements(dot)com> wrote:
> We are having only two disk (40GB each). One disk is used for OS, App
> Server, and application. Second disk is used for postgresql database.
> It's a dual cpu machine having 2 GB of ram.

Even a single disk, with a battery backed caching controller will
generally run things like updates and inserts much faster, and is
usually a much better performance under load than a single disk.

I'd at least look at mirroring them for redundancy and better read performance.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Sachchida Ojha 2007-08-21 22:20:02 Re: Autovacuum is running forever
Previous Message Sachchida Ojha 2007-08-21 22:07:44 Re: Autovacuum is running forever