shared buffers

PostgreSQL is the database server used to store information. Do you have a question or are you having problem with PostgreSQL? If so, post them here.

Moderator: Moderators

shared buffers

Postby zedjr » Thu Jul 23, 2009 8:20 pm

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
zedjr
 
Posts: 198
Joined: Mon Feb 04, 2008 6:28 pm

Re: shared buffers

Postby zedjr » Fri Jul 24, 2009 8:12 am

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.
zedjr
 
Posts: 198
Joined: Mon Feb 04, 2008 6:28 pm


Return to PostgreSQL [Read Only]

Who is online

Users browsing this forum: No registered users and 34 guests

cron
highfalutin