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

Re: Postgres configuration for 64 CPUs, 128 GB RAM...

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: "Marc Mamin" <M(dot)Mamin(at)intershop(dot)de>
Subject: Re: Postgres configuration for 64 CPUs, 128 GB RAM...
Date: 2007-07-20 23:26:07
Message-ID: 200707201626.08281.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-performance
Marc,

> Server Specifications:
> ----------------------
>
> Sun SPARC Enterprise M8000 Server:
>
> http://www.sun.com/servers/highend/m8000/specs.xml
>
> File system:
>
> http://en.wikipedia.org/wiki/ZFS

There are some specific tuning parameters you need for ZFS or performance 
is going to suck.

http://www.solarisinternals.com/wiki/index.php/ZFS_Best_Practices_Guide
(scroll down to "PostgreSQL")
http://www.sun.com/servers/coolthreads/tnb/applications_postgresql.jsp
http://bugs.opensolaris.org/view_bug.do?bug_id=6437054

You also don't say anything about what kind of workload you're running.


-- 
--Josh

Josh Berkus
PostgreSQL @ Sun
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Josh BerkusDate: 2007-07-20 23:28:27
Subject: Re: large number of connected connections to postgres database (v8.0)
Previous:From: Jignesh K. ShahDate: 2007-07-20 21:24:33
Subject: Re: User concurrency thresholding: where do I look?

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