Re: Question about memory allocations

Поиск
Список
Период
Сортировка
От Andrew McMillan
Тема Re: Question about memory allocations
Дата
Msg-id 1176453355.609.4.camel@hippy.mcmillan.net.nz
обсуждение исходный текст
Ответ на Question about memory allocations  (Steve <cheetah@tanabi.org>)
Ответы Re: Question about memory allocations  (Steve <cheetah@tanabi.org>)
Список pgsql-performance
On Tue, 2007-04-10 at 15:28 -0400, Steve wrote:
>
> I'm trying to tune the memory usage of a new machine that has a -lot- of
> memory in it (32 gigs).

...
>
> shared_buffers = 16GB

Really?

Wow!

Common wisdom in the past has been that values above a couple of hundred
MB will degrade performance.  Have you done any benchmarks on 8.2.x that
show that you get an improvement from this, or did you just take the
"too much of a good thing is wonderful" approach?

Cheers,
                    Andrew.

-------------------------------------------------------------------------
Andrew @ Catalyst .Net .NZ  Ltd,  PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/            PHYS: Level 2, 150-154 Willis St
DDI: +64(4)803-2201      MOB: +64(272)DEBIAN      OFFICE: +64(4)499-2267
 You have an unusual equipment for success.  Be sure to use it properly.
-------------------------------------------------------------------------


Вложения

В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Strangely Variable Query Performance
Следующее
От: "Avdhoot Kishore Saple"
Дата:
Сообщение: local selectivity estimation - computing frequency of predicates