Re: how much memory to allot to postgres? - Mailing list pgsql-general

From Francisco J Reyes
Subject Re: how much memory to allot to postgres?
Date
Msg-id 20030129133020.C81102-100000@zoraida.natserv.net
Whole thread Raw
In response to Re: how much memory to allot to postgres?  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
List pgsql-general
On Tue, 28 Jan 2003, Shridhar Daithankar wrote:

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

Just checked my values and I have 128MB for vacuum and sort. Is that
overkill?

2GB ram also, but usually only have a handfull of connections.
Given that WAL buffer is listed in 8K block (correct?) then 10MB would be
1310720?

It seems I only have 2MB of WAL buffer.. I have large daily loads of data.
Will a number above 10MB help? ie 16MB


pgsql-general by date:

Previous
From: KK
Date:
Subject: Re: Firewalls and Postgres
Next
From: "Ivar"
Date:
Subject: Postgre vs SAP Db