Hi all,
I am running postgres 7.4.2 on a Dual processor Opteron with 16GB of ram. I
want to set shared_buffers to a large value, but I am running into startup
problems.
I have set my kernel SHMMAX and SHMALL to 12GB.
When I set shared_buffers to a value which puts the total shared memory
usage over 1GB, my postgres server fails to start. Unfortunatly, I also
cannot seem to get any logfile output out of my system (perhaps another
question).
Are there any hardcoded max values for shared_buffers? I noticed in the code
that a uint32 is used for the page size which would mean a 4GB max. This is
failing at much lower values.
Sorry that I do not have a logfile output. Perhaps someone could help me
turn my logfile on. I am passing -l logfile at startup, but my logfile
remains empty.
Thanks in advance
Barry
(ba***@GeipelNet.com 2 4822
Hello,
What operating system?
Sincerely,
Joshua D. Drake
Barry L. Geipel wrote: -->
Hi all, I am running postgres 7.4.2 on a Dual processor Opteron with 16GB of ram. I want to set shared_buffers to a large value, but I am running into startup problems. I have set my kernel SHMMAX and SHMALL to 12GB. When I set shared_buffers to a value which puts the total shared memory usage over 1GB, my postgres server fails to start. Unfortunatly, I also cannot seem to get any logfile output out of my system (perhaps another question). Are there any hardcoded max values for shared_buffers? I noticed in the code that a uint32 is used for the page size which would mean a 4GB max. This is failing at much lower values. Sorry that I do not have a logfile output. Perhaps someone could help me turn my logfile on. I am passing -l logfile at startup, but my logfile remains empty. Thanks in advance Barry
(ba***@GeipelNet.com
--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL
"Barry L. Geipel" <ba***@GeipelNet.com> writes: When I set shared_buffers to a value which puts the total shared memory usage over 1GB, my postgres server fails to start.
You definitely can't set shared memory to more than 2GB because its
allocation arithmetic is done with ints. Not sure why it would fall
over at 1GB, but it's more or less irrelevant anyway, because there is
no earthly reason to make shared_buffers that high. You are much better
off leaving the kernel to manage the bulk of your RAM. I don't know of
any substantiated cases where it helped to make shared_buffers much
larger than order-of-magnitude-of-10000 (80MB). 1GB will certainly be
well past the point of diminishing returns.
You can find more about this in the pgsql-performance archives, I believe.
If not there, try older archives of the other lists.
Sorry that I do not have a logfile output. Perhaps someone could help me turn my logfile on. I am passing -l logfile at startup, but my logfile remains empty.
Passing -l logfile to what?
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: DJTB |
last post by:
zodb-dev@zope.org]
Hi,
I'm having problems storing large amounts of objects in a ZODB.
After committing changes to the database, elements are not cleared from
memory. Since the number of...
|
by: BBFrost |
last post by:
We just recently moved one of our major c# apps from VS Net 2002 to VS Net
2003. At first things were looking ok, now problems are starting to
appear.
So far ...
(1) ...
|
by: Madison Kelly |
last post by:
Hi all,
I have got to say that my first foray into postgresSQL is becoming a
very madening experience... I am sure it is my own fault for not knowing
very much but it seems that everything I...
|
by: Adam Witney |
last post by:
Forwarding to the mailing list, as I don't know how to fix it....
------ Forwarded Message
From: Henning Klein <kleinh@rz.uni-potsdam.de>
Date: Tue, 22 Jun 2004 22:09:08 +0200
To:...
|
by: Josh Close |
last post by:
I keep getting this error.
DETAIL: Failed system call was shmget(key=5432001, size=34037760, 03600).
HINT: This error usually means that PostgreSQL's request for a shared
memory segment...
| |
by: BARTKO, Zoltán |
last post by:
Hello, folks,
I am trying to install pgsql8 on winxp. I tried first to install "as
is" with pginstaller beta2-dev3, no luck, it froze, switched off
Nod32, froze a little later, ran through the...
|
by: UJ |
last post by:
I have a page where the user can upload a video file. As you can guess, this
may take a while. Is there a way I can change the session timeout for just
this one page? I would also want to change...
|
by: =?Utf-8?B?TWFkcyBOaWVsc2Vu?= |
last post by:
Hi,
I am developing a web service for a customer. The service has a method, that
returns an array of Forms. Each form has a Name property of Type String.
The customer wants the contract to...
|
by: =?Utf-8?B?bWljaGFlbCBzb3JlbnM=?= |
last post by:
I have worked with application settings in VS2005 and C# for awhile, but
usually with standard types. I have been trying to store a custom
container/class/type in an application setting and I have...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...
| |