Re: scaling up postgres

Поиск
Список
Период
Сортировка
От John Vincent
Тема Re: scaling up postgres
Дата
Msg-id c841561b0606131440i526c738fme96d6f1b6dc6b777@mail.gmail.com
обсуждение исходный текст
Ответ на Re: scaling up postgres  ("Jim C. Nasby" <jnasby@pervasive.com>)
Ответы Re: scaling up postgres  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-performance
Maybe from a postgresql perspective the cpus may be useless but the memory on the pSeries can't be beat. We've been looking at running our warehouse (PGSQL) in a LoP lpar but I wasn't able to find a LoP build of 8.1.

We've been thrilled with the performance of our DB2 systems that run on AIX/Power 5 but since the DB2 instance memory is limited to 18GB, we've got two 86GB p570s sitting there being under utilized.


FYI,

I've not seen my posts showing up on the list or the archives so I'm hoping this gets through.

On 6/13/06, Jim C. Nasby < jnasby@pervasive.com> wrote:
On Tue, Jun 13, 2006 at 10:14:44PM +0200, PFC wrote:
>
> >Uhm... stick with commodity CPUs?
>
>       Hehe, does this include Opterons ?

Absolutely. Heck, it wouldn't surprise me if a single model # of Opteron
sold more than all Power CPUs put together...

>       Still, I looked on the "customize your server" link someone posted
>       and  it's amazing ; these things have become cheaper while I wasn't
> looking...
>       You can buy 10 of these boxes with raptors and 4 opteron cores and 8
>       gigs  of RAM for the price of your average marketing boss's car...
> definitely  makes you think doesn't it.

And if you spend that much on CPU for a database, you're likely to be
pretty sadly disappointed, depending on what you're doing.

>       Juts wait until someone equates the price in man-hours to fix/run a
> borken Dell box...

Would probably sound like a Mastercard commercial...

Not having to babysit your servers every day: Priceless
--
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
       choose an index scan if your joining column's datatypes do not
       match



--
John E. Vincent
lusis.org@gmail.com

В списке pgsql-performance по дате отправления:

Предыдущее
От: "Shaun Thomas"
Дата:
Сообщение: Re: Confirmation of bad query plan generated by 7.4
Следующее
От: "Jim C. Nasby"
Дата:
Сообщение: Re: Confirmation of bad query plan generated by 7.4