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