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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-performance by date

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