From: Mathieu Gilardet <mgilardet@alaloop.com>
To: pgsql-performance@postgresql.org
Subject: RAM / Disk ratio, any rule?
Date: Wed, 04 Jun 2008 16:02:23 +0200
Message-ID: <4846A06F.3090907@alaloop.com> (raw)
hello,
I am wondering if actually, does exists any rule to determine
the amount of RAM, according to the hardware disk size
(in prevision to use all or nearly available space),
when designing a server?
Of course fsm settings implies that when db size grows, more memory will
be in use
for tracking free space.
Same thing applies from RAM cache effectiveness: the bigger db size is,
the more RAM is needed.
Do be more specific, we have an heavy loaded server with SCSI disks
(RAID 0 on a SAS controller),
making a total of 500GB. Actually, there are 16GB RAM, representing
about 2,5% of db size.
any experiences to share?
in advance, thank you.
Mathieu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mgilardet@alaloop.com
Subject: Re: RAM / Disk ratio, any rule?
In-Reply-To: <4846A06F.3090907@alaloop.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox