Re: how much memory to allot to postgres?

On 27 Jan 2003 at 13:17, Brian Maguire wrote:

> What is the suggested rule of thumb in allotting memory to postgres on a
> production level transactional database?

Well, that depends upon your database size and data and transaction pattern. It
is a very subjective question.
>
> If this was an example config, how much would you suggest allotting?
>
> Redhat 7.3
> 2 Gig EMC Ram
> Dual Pentium 1.7 mhz

15000 shared buffers + 10Mb of WAL cache + 4MB of sort mem(Note this is per
client) should be enough to handle enough data.

Bye
 Shridhar

--
Change is the essential process of all existence.        -- Spock, "Let That Be Your
Last Battlefield", stardate 5730.2