initdb could use some lower default settings (trivial patch)

Started by Nonameabout 22 years ago2 messagesbugs
Jump to latest
#1Noname
evanm@frap.net

Installing postgres on a Solaris 8 system for personal use, I discovered that
initdb exceeded the shared memory available on my system (Default settings).
There's enough to run the database, but initdb doesn't probe to low enough
values:

for nconns in 100 50 40 30 20 10
for nbuffers in 1000 900 800 700 600 500 400 300 200 100 50

10/50 is too large, the largest Solaris can handle without changing the
defaults is 10/46. I think it'd be a good idea if initdb probed at least a
little lower here, say to a buffer size of 25, to let it install on Solaris
with default shmem settings.

Please CC me, as I'm not subscribed to these lists.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Noname (#1)
Re: initdb could use some lower default settings (trivial patch)

evanm@frap.net writes:

10/50 is too large, the largest Solaris can handle without changing the
defaults is 10/46. I think it'd be a good idea if initdb probed at least a
little lower here, say to a buffer size of 25, to let it install on Solaris
with default shmem settings.

Actually, I'd rather than the minimum probed were higher not lower.
Performance with only 25 buffers is going to be so awful that I think
we are better off forcing the user to increase his shmem setting
instead.

regards, tom lane