Re: requested shared memory size overflows size_t

От: Stephen Frost
Тема: Re: requested shared memory size overflows size_t
Дата: ,
Msg-id: 20100602205957.GN21875@tamriel.snowman.net
(см: обсуждение, исходный текст)
Ответ на: Re: requested shared memory size overflows size_t  ("Kevin Grittner")
Список: pgsql-performance

Скрыть дерево обсуждения

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

Вложения

В списке pgsql-performance по дате сообщения:

От: Joshua Tolley
Дата:
Сообщение: Re: requested shared memory size overflows size_t
От: Matthew Wakeling
Дата:
Сообщение: Re: SELECT ignoring index even though ORDER BY and LIMIT present