Fwd: large cache

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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/

-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux