Re: requested shared memory size overflows size_t

From: Stephen Frost
Subject: Re: requested shared memory size overflows size_t
Date: ,
Msg-id: 20100602205957.GN21875@tamriel.snowman.net
(view: Whole thread, Raw)
In response to: Re: requested shared memory size overflows size_t  ("Kevin Grittner")
List: pgsql-performance

Tree view

requested shared memory size overflows size_t  ("Uwe Bartels", )
 Re: requested shared memory size overflows size_t  (Tom Lane, )
  Re: requested shared memory size overflows size_t  ("Stephen Conley", )
 Re: requested shared memory size overflows size_t  (Tom Wilcox, )
  Re: requested shared memory size overflows size_t  ("Kevin Grittner", )
   Re: requested shared memory size overflows size_t  (Stephen Frost, )
  Re: requested shared memory size overflows size_t  (Bob Lunney, )
   Re: requested shared memory size overflows size_t  (Robert Haas, )
    Re: requested shared memory size overflows size_t  (Bob Lunney, )
  Re: requested shared memory size overflows size_t  (Joshua Tolley, )
 Re: requested shared memory size overflows size_t  (Bob Lunney, )
  Re: requested shared memory size overflows size_t  (Tom Wilcox, )
   Re: requested shared memory size overflows size_t  (Robert Haas, )
    Re: requested shared memory size overflows size_t  (Tom Wilcox, )
     Re: requested shared memory size overflows size_t  (Greg Smith, )
      Re: requested shared memory size overflows size_t  (Tom Wilcox, )
       Re: requested shared memory size overflows size_t  (Kenneth Marshall, )
        Re: requested shared memory size overflows size_t  (Greg Smith, )
         Re: requested shared memory size overflows size_t  (Craig James, )
          Re: requested shared memory size overflows size_t  (Alvaro Herrera, )
           Re: System tables screwed up? (WAS requested shared memory size overflows size_t)  (Craig James, )
            Re: System tables screwed up? (WAS requested shared memory size overflows size_t)  (Alvaro Herrera, )
           Re: requested shared memory size overflows size_t  (Robert Haas, )
            Re: requested shared memory size overflows size_t  (Jim Montgomery, )
   Re: requested shared memory size overflows size_t  (Dave Crooke, )
    Re: requested shared memory size overflows size_t  (Tom Wilcox, )
     Re: requested shared memory size overflows size_t  (Dave Crooke, )
      Re: requested shared memory size overflows size_t  (Tom Wilcox, )
   Re: requested shared memory size overflows size_t  (Greg Smith, )
    Re: requested shared memory size overflows size_t  (Scott Carey, )
     Re: requested shared memory size overflows size_t  (Tom Lane, )
      Re: requested shared memory size overflows size_t  (Alvaro Herrera, )
       Re: requested shared memory size overflows size_t  (Scott Carey, )
   Re: requested shared memory size overflows size_t  (Scott Carey, )

* Kevin Grittner () wrote:
> Tom Wilcox <> wrote:
> > Is it possible to get postgres to make use of the available 96GB
> > RAM on a Windows 32-bit build?
>
> I would try setting shared_memory to somewhere between 200MB and 1GB
> and set effective_cache_size = 90GB or so.  The default behavior of
> Windows was to use otherwise idle RAM for disk caching, last I
> checked, anyway.

Sure, but as explained on -general already, all that RAM will only ever
get used for disk cacheing.  It won't be able to be used for sorts or
hash aggs or any other PG operations (PG would use at most
4GB-shared_buffers, or so).

    Thanks,

        Stephen

Attachment

pgsql-performance by date:

From: Mark Kirkwood
Date:
Subject: Re: Weird XFS WAL problem
From: Bob Lunney
Date:
Subject: Re: requested shared memory size overflows size_t