Re: separate drives for WAL or pgdata files - Mailing list pgsql-performance

From David Lang
Subject Re: separate drives for WAL or pgdata files
Date
Msg-id Pine.LNX.4.62.0512191937340.2807@qnivq.ynat.uz
Whole thread Raw
In response to Re: separate drives for WAL or pgdata files  (David Lang <dlang@invendra.net>)
List pgsql-performance
On Mon, 19 Dec 2005, David Lang wrote:

> this is getting dangerously close to being able to fit in ram. I saw an
> article over the weekend that Samsung is starting to produce 8G DIMM's, that
> can go 8 to a controller (instead of 4 per as is currently done), when
> motherboards come out that support this you can have 64G of ram per opteron
> socket. it will be pricy, but the performance....

a message on another mailing list got me to thinking, there is the horas
project that is aiming to put togeather 16 socket Opteron systems within a
year (they claim sooner, but I'm being pessimistic ;-), combine this with
these 8G dimms and you can have a SINGLE system with 1TB of ram on it
(right at the limits of the Opteron's 40 bit external memory addressing)

_wow_

and the thing it that it won't take much change in the software stack to
deal with this.

Linux is already running on machines with 1TB of ram (and 512 CPU's) so it
will run very well. Postgres probably needs some attention to it's locks,
but it is getting that attention now (and it will get more with the Sun
Niagra chips being able to run 8 processes simultaniously)

just think of the possibilities (if you have the money to afford the super
machine :-)

David Lang


pgsql-performance by date:

Previous
From: David Lang
Date:
Subject: Re: separate drives for WAL or pgdata files
Next
From: "Jignesh K. Shah"
Date:
Subject: Re: High context switches occurring