RAM / Disk ratio, any rule?

From: Mathieu Gilardet <mgilardet(at)alaloop(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: RAM / Disk ratio, any rule?
Date: 2008-06-04 14:02:23
Message-ID: 4846A06F.3090907@alaloop.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Lewis Kapell 2008-06-04 14:44:25 backend pid changing
Previous Message Matthew Wakeling 2008-06-04 10:31:22 Re: insert/update tps slow with indices on table > 1M rows