Re: Working on huge RAM based datasets - Mailing list pgsql-performance

From Jan Wieck
Subject Re: Working on huge RAM based datasets
Date
Msg-id 40F2D1E6.10504@Yahoo.com
Whole thread Raw
In response to Re: Working on huge RAM based datasets  (Josh Berkus <josh@agliodbs.com>)
List pgsql-performance
On 7/12/2004 12:38 PM, Josh Berkus wrote:

> Rond, Chris,
>
>> > What would be most interesting to see is whether this makes it wise to
>> > increase shared buffer size.  It may be more effective to bump down
>> > the cache a little, and bump up sort memory; hard to tell.
>>
>> How do we go about scheduling tests with the OSDL folks? If they could
>> do 10 runs with buffers between 1k and 500k it would help us get a broad
>> view of the situation.
>
> Yes.   We'll need to.   However, I'd like to wait until we're officially in
> Beta.   I'll be seeing the OSDL folks in person (PostgreSQL+OSDL BOF at Linux
> World Expo!!)  in a couple of weeks.
>

Don't forget to add that ARC needs some time actually to let the
algorithm adjust the queue sizes and populate the cache according to the
access pattern. You can't start a virgin postmaster and then slam on the
accellerator of your test application by launching 500 concurrent
clients out of the blue and expect that it starts off airborne.


Jan

--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Working on huge RAM based datasets
Next
From: Laurent Martelli
Date:
Subject: Re: Fw: invitation au "Village du Logiciel Libre" de la