Re: Postgres configuration for 64 CPUs, 128 GB RAM... - Mailing list pgsql-performance

From Josh Berkus
Subject Re: Postgres configuration for 64 CPUs, 128 GB RAM...
Date
Msg-id 200707201626.08281.josh@agliodbs.com
Whole thread Raw
In response to Postgres configuration for 64 CPUs, 128 GB RAM...  ("Marc Mamin" <M.Mamin@intershop.de>)
Responses Re: Postgres configuration for 64 CPUs, 128 GB RAM...
List 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

pgsql-performance by date:

Previous
From: "Jignesh K. Shah"
Date:
Subject: Re: User concurrency thresholding: where do I look?
Next
From: Josh Berkus
Date:
Subject: Re: large number of connected connections to postgres database (v8.0)