Fwd: large cache

From: Brian Modra <epailty(at)googlemail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Fwd: large cache
Date: 2009-06-30 05:19:13
Message-ID: 5a9699850906292219y4e497dfav3cd5fc3d95496ee8@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
my database requires 1TB of disk space, but I want to avoid RAID (e.g.
8x 300GB SAS drives in RAID 10), and use rather a 1TB SATA disk.
To avoid the "slowness" of SATA showing in queries, I want to cache
lots of the database, but I don't want to buy more than 16GB RAM.
(Budget limits).
So I'm considering configuring a large cache, requiring larger than
16GB, and allowing it to "spill over" into swap space on a single
300GB SAS drive.

Is this a good idea?

Thanks
Brian

--
Brian Modra   Land line: +27 23 5411 462
Mobile: +27 79 69 77 082
5 Jan Louw Str, Prince Albert, 6930
Postal: P.O. Box 2, Prince Albert 6930
South Africa
http://www.zwartberg.com/

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2009-06-30 05:50:58 Re: Fwd: large cache
Previous Message Chandra Sekar R 2009-06-30 05:10:58 Re: unable to create new table