Re: Benchmarking a large server

Поиск
Список
Период
Сортировка
Искать
От
david@lang.hm
Тема
Re: Benchmarking a large server
Дата
в 21:46:36
Msg-id
alpine.DEB.2.00.1105091745010.25291@asgard.lang.hm
Ответ на
Список
Дерево обсуждения
Benchmarking a large server Chris Hoover <revoohc@gmail.com>
Re: Benchmarking a large server Shaun Thomas <sthomas@peak6.com>
Re: Benchmarking a large server Greg Smith <greg@2ndQuadrant.com>
Re: Benchmarking a large server Yeb Havinga <yebhavinga@gmail.com>
Re: Benchmarking a large server Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Benchmarking a large server Craig James <craig_james@emolecules.com>
Re: Benchmarking a large server David Boreham <david_list@boreham.org>
Re: Benchmarking a large server Shaun Thomas <sthomas@peak6.com>
Re: Benchmarking a large server Greg Smith <greg@2ndQuadrant.com>
Re: Benchmarking a large server Greg Smith <greg@2ndquadrant.com>
Re: Benchmarking a large server Cédric Villemain <cedric.villemain.debian@gmail.com>
Re: Benchmarking a large server david@lang.hm
Re: Benchmarking a large server Greg Smith <greg@2ndquadrant.com>
Re: Benchmarking a large server Merlin Moncure <mmoncure@gmail.com>
Re: Benchmarking a large server Jeff <threshar@torgo.978.org>
Re: Benchmarking a large server David Boreham <david_list@boreham.org>
Re: Benchmarking a large server Merlin Moncure <mmoncure@gmail.com>
Re: Benchmarking a large server David Boreham <david_list@boreham.org>
Re: Benchmarking a large server Claudio Freire <klaussfreire@gmail.com>
Re: Benchmarking a large server Ben Chobot <bench@silentmedia.com>
On Mon, 9 May 2011, David Boreham wrote:

> On 5/9/2011 6:32 PM, Craig James wrote:
>> Maybe this is a dumb question, but why do you care?  If you have 1TB RAM 
>> and just a little more actual disk space, it seems like your database will 
>> always be cached in memory anyway.  If you "eliminate the cach effect," 
>> won't the benchmark actually give you the wrong real-life results?
>
> The time it takes to populate the cache from a cold start might be important.

you may also have other processes that will be contending with the disk 
buffers for memory (for that matter, postgres may use a significant amount 
of that memory as it's producing it's results)

David Lang

> Also, if it were me, I'd be wanting to check for weird performance behavior 
> at this memory scale.
> I've seen cases in the past where the VM subsystem went bananas because the 
> designers
> and testers of its algorithms never considered the physical memory size we 
> deployed.
>
> How many times was the kernel tested with this much memory, for example ? 
> (never??)
>
>
>
>
В списке pgsql-performance по дате отправления
От: Greg Smith
Дата:
От: Aren Cambre
Дата:
FAQ