Page 1 of 1

shared buffers

PostPosted: Thu Jul 23, 2009 8:20 pm
by zedjr
Anytime i set shared buffers above 1024mb it wont load any postgres services after it sits at boot up forever it seems. HAve tried this on another xeon machine with 8gb of ram adn this one with 12gb of ram. I ahve this now on 8.4 postgres but had same problem on 8.3. What is the trick to get this higher so it will load postgres. thanks

Re: shared buffers

PostPosted: Fri Jul 24, 2009 8:12 am
by zedjr
what i have read i have to set the kernel. how and waht to do am not totally as is confusing for something that isnt a programmer or a postgresql expert. is shmmax files. IS there any dumbies guide anyone knows of to change this on my machine. here are the two links i am reading. first is wiki on shared buffers. http://wiki.postgresql.org/wiki/Tuning_ ... SQL_Server. then next is about managing kernel resourceshttp://www.postgresql.org/docs ... urces.html . it list operating systems in later but i dont see pc or vista listed and dont know waht alot of thsoe listings even mean. any help is appreciated or a service i can pay that helps with these kinds of things.