| From: | Brian Modra <brian(at)zwartberg(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | large cache |
| Date: | 2009-06-29 08:01:53 |
| Message-ID: | 5a9699850906290101h29338d15o1c2eeccd5ff32cff@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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Uwe Bartels | 2009-06-29 08:40:24 | analyze anomalie |
| Previous Message | Chandra Sekar R | 2009-06-29 06:20:15 | unable to create new table |