Re: separate drives for WAL or pgdata files

Поиск
Список
Период
Сортировка
От David Lang
Тема Re: separate drives for WAL or pgdata files
Дата
Msg-id Pine.LNX.4.62.0512191937340.2807@qnivq.ynat.uz
обсуждение исходный текст
Ответ на Re: separate drives for WAL or pgdata files  (David Lang <dlang@invendra.net>)
Список 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 по дате отправления:

Предыдущее
От: David Lang
Дата:
Сообщение: Re: separate drives for WAL or pgdata files
Следующее
От: "Jignesh K. Shah"
Дата:
Сообщение: Re: High context switches occurring