"Brian Maguire" <bmaguire@vantage.com> writes:
> What is the suggested rule of thumb in allotting memory to postgres on a
> production level transactional database? 1/2, 3/4 ?
I'd go with a few thousand shared_buffers and leave it at that.
You can find plenty of discussion of this issue in the mail list
archives; there's more than one school of thought ...
There are other things to worry about btw; sort_mem and
max_fsm_relations/pages in particular are too small by default.
regards, tom lane
