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
