Skip site navigation (1) Skip section navigation (2)

Re: Working on huge RAM based datasets

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Rod Taylor <pg(at)rbt(dot)ca>, Christopher Browne <cbbrowne(at)acm(dot)org>
Cc: Postgresql Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Working on huge RAM based datasets
Date: 2004-07-12 16:38:01
Message-ID: 200407120938.01764.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
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.

-- 
Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Jim EwertDate: 2004-07-12 16:59:05
Subject: Swapping in 7.4.3
Previous:From: Rod TaylorDate: 2004-07-12 14:38:08
Subject: Re: Working on huge RAM based datasets

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group