Forum OpenACS Q&A: Re: postgresql startup script

Collapse
6: Re: postgresql startup script (response to 1)
Posted by Jon Griffin on 11/12/02 11:35 PM
-B is short for shared buffers which I assumed were not the same as cache buffers. It is sort of related to max connections. I only raised it from the default because I have my PG server as a backend to some other servers and I ran out of connections.

It works fine for me, but coming from Oracle I could be completly wrong.

Collapse
7: Re: postgresql startup script (response to 6)
Posted by Jeff Davis on 11/13/02 11:56 PM
I think the -B flag is in fact the cache buffer. Here is an article by Bruce Momjian which is where I got that.

Anyway, there don't seem to be anywhere near as many knobs to turn on postgresql as on oracle but sadly even less guidance about how to turn those knobs that there is on oracle. Roberto also pointed me at this tuning article but I am not so sure about it since one thing he does is set fsync=false with no real discussion of the consequences.

Collapse
8: Re: postgresql startup script (response to 7)
Posted by mark dalrymple on 11/14/02 12:10 AM
If folks have money to spend, Bruce Momjian is doing a hard core Postgresql class in conjunction with the Big Nerd Ranch folks. (Disclaimer, I teach a mac programming class for the Big Nerd Ranch)