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