Re: how much memory to allot to postgres?

"Shridhar Daithankar" <shridhar_daithankar@persistent.co.in> writes:
> On 29 Jan 2003 at 13:34, Francisco J Reyes wrote:
>> Just checked my values and I have 128MB for vacuum and sort. Is that
>> overkill?

> Absolutely. Especially sort mem. If you are allocatingg 128MB sort mem for each
> connection, you will soon be dry with memory. I would say 8MB to 16MB sort
> memory depending upon number of conenctions you want to entertain at a time.
> Just remember it is per connection.

Worse than that: it's per sort step (or hash step).  It's not at all
unlikely that an N-table query would be running N-1 sorts or hashes in
parallel; plus maybe more to implement aggregation, grouping, ORDER BY,
etc.  So unless all your queries are very simple, you'd better figure
on some multiple of sort_mem per connection.

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

> 16MB is good.

16MB is probably vast overkill.  Are you able to measure any change in
performance at all from increasing wal_buffers?  I can't see a reason
that more than a dozen or so wal buffers would be useful.  Almost
certainly, those megabytes would be more effectively used as
general-purpose kernel disk cache.

            regards, tom lane