[nycbug-talk] Memory sizing

[Charles Sprickman]

On Sat, 22 Apr 2006, Pete Wright wrote:

> On Fri, Apr 21, 2006 at 11:47:56PM -0400, Francisco Reyes wrote:
>> Soon to buy a couple of new server and wondering if we should get 4GB or
>> 8GB. My first stop is trying to better understand memory utilization.
>>
>> Any suggested links?
>
> what is the profile on queries you are going to running against the
> DB?  are we looking at lot's of small queries, periodic quries on large
> data set's or something in between.  i am in the process of building a
> large postgres server that is going to be doing data warehousing, we are
> thinking that we should be fine with 4gig's or RAM as we will not have
> many concurrent connections.

Another resource (besides this fine list) is the Postgresql-performance 
list.  They gladly entertain all sorts of questions about memory sizing, 
query optimization, RAID controllers, etc.

Lots of very good (and forward-thinking) knowledge on that list.

Charles

> HTH
> -p
>
>
> -- 
> ~~oO00Oo~~
> Peter Wright
> pete at nomadlogic.org
> www.nomadlogic.org/~pete
> 310.869.9459
>
> _______________________________________________
> % NYC*BUG talk mailing list
> http://lists.nycbug.org/mailman/listinfo/talk
> %Be sure to check out our Jobs and NYCBUG-announce lists
> %We meet the first Wednesday of the month
>