pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  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:43  Joshua D. Drake <jd@commandprompt.com>
  parent: Crowson, Sarah J Ms (Contractor) Northrop Grumman <Sarah.Crowson@us.army.mil>
  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