[nycbug-talk] Memory sizing

Charles Sprickman spork at bway.net
Sat Apr 22 18:58:20 EDT 2006

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.


> -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

More information about the talk mailing list