pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Re: Fatal: 2149478 (UNCLASSIFIED) (UNCLASSIFIED) 2+ messages / 2 participants [nested] [flat]
* Re: Fatal: 2149478 (UNCLASSIFIED) (UNCLASSIFIED) @ 2006-05-11 17:39 Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil> 2006-05-11 17:43 ` Re: Fatal: 2149478 (UNCLASSIFIED) (UNCLASSIFIED) Joshua D. Drake <jd@commandprompt.com> 0 siblings, 1 reply; 2+ messages in thread From: Crowson, Sarah J Ms (Contractor) Northrop Grumman @ 2006-05-11 17:39 UTC (permalink / raw) To: Tom Lane <tgl@sss.pgh.pa.us>; Joshua D. Drake <jd@commandprompt.com>; +Cc: Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>; pgsql-admin Classification: UNCLASSIFIED Caveats: NONE I am currently working on figuring out the size of my systems. It looks to me like I am dealing with 2 gig systems.. Although on our road servers (we travel) we are dealing with 12 gig systems. Unfortunately I have had hit or miss problems with these work_mem and maintenance_mem calculations.. On some systems they work.. On some they don't. Here is the calculations that we are using (these were developed by a employee that no longer works here). Shared_buffers = (total_mem_mb * 1024 * .06) / 8 SHMMAX = (shared_buffers * 8 * 1.2) * 1024 SHMALL = (total_mem_mb * 1024 *4) WORK_MEM = (free_mem_mb * 1024 *.02) MAINTENANCE_WORK_MEM = (free_mem_mb * 1024 * .3) -----Original Message----- From: Tom Lane [mailto:tgl@sss.pgh.pa.us] Sent: Thursday, May 11, 2006 12:29 PM To: Joshua D. Drake Cc: Crowson, Sarah J Ms (Contractor) Northrop Grumman; 'pgsql-admin@postgresql.org' Subject: Re: [ADMIN] Fatal: 2149478 (UNCLASSIFIED) "Joshua D. Drake" <jd@commandprompt.com> writes: >> Fatal: 2149478 is outside the valid range for parameter >> "maintenance_work_mem" ............ > That is odd. I just testing on 8.1.3: > template1=# set maintenance_work_mem = 2149478; SET I'm betting Joshua is testing on a 64-bit machine. Since 8.1, the max allowed value is dependent on sizeof(pointer) ... regards, tom lane Classification: UNCLASSIFIED Caveats: NONE ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Fatal: 2149478 (UNCLASSIFIED) (UNCLASSIFIED) 2006-05-11 17:39 Re: Fatal: 2149478 (UNCLASSIFIED) (UNCLASSIFIED) Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil> @ 2006-05-11 17:43 ` Joshua D. Drake <jd@commandprompt.com> 0 siblings, 0 replies; 2+ messages in thread From: Joshua D. Drake @ 2006-05-11 17:43 UTC (permalink / raw) To: Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>; +Cc: 'Tom Lane' <tgl@sss.pgh.pa.us>; pgsql-admin >> That is odd. I just testing on 8.1.3: > >> template1=# set maintenance_work_mem = 2149478; SET > > I'm betting Joshua is testing on a 64-bit machine. Since 8.1, the max > allowed value is dependent on sizeof(pointer) ... Oops... yes my test workstation is a Dual Core AMD64. Sincerely, Joshua D. Drake > > regards, tom lane > Classification: UNCLASSIFIED > Caveats: NONE > -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240 Providing the most comprehensive PostgreSQL solutions since 1997 http://www.commandprompt.com/ ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-05-11 17:43 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-05-11 17:39 Re: Fatal: 2149478 (UNCLASSIFIED) (UNCLASSIFIED) Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil> 2006-05-11 17:43 ` Joshua D. Drake <jd@commandprompt.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox