pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedRAM / Disk ratio, any rule?
2+ messages / 2 participants
[nested] [flat]
* RAM / Disk ratio, any rule?
@ 2008-06-04 14:02 Mathieu Gilardet <mgilardet@alaloop.com>
0 siblings, 1 reply; 2+ messages in thread
From: Mathieu Gilardet @ 2008-06-04 14:02 UTC (permalink / raw)
To: pgsql-performance
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: RAM / Disk ratio, any rule?
@ 2008-06-05 00:32 Greg Smith <gsmith@gregsmith.com>
parent: Mathieu Gilardet <mgilardet@alaloop.com>
0 siblings, 0 replies; 2+ messages in thread
From: Greg Smith @ 2008-06-05 00:32 UTC (permalink / raw)
To: Mathieu Gilardet <mgilardet@alaloop.com>; +Cc: pgsql-performance
On Wed, 4 Jun 2008, Mathieu Gilardet wrote:
> 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.
That's a reasonable ratio. Being able to hold somewhere around 1 to 5% of
the database in RAM seems to common nowadays, and that works OK. But it's
impossible to have a hard "rule" here because the working set needed to
operate the queries and other activities on your server is completely
dependant on the code you're running, your performance expectations, and
your expected user load.
--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2008-06-05 00:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-06-04 14:02 RAM / Disk ratio, any rule? Mathieu Gilardet <mgilardet@alaloop.com>
2008-06-05 00:32 ` Greg Smith <gsmith@gregsmith.com>
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