Re: Sun Fire T2000 and PostgreSQL 8.1.3

From: "Jignesh K(dot) Shah" <J(dot)K(dot)Shah(at)Sun(dot)COM>
To: Leigh Dyer <leigh(at)eclinic(dot)com(dot)au>
Cc: Luke Lonergan <llonergan(at)greenplum(dot)com>, "Juan Casero (FL FLC)" <Juan(dot)Casero(at)wholefoods(dot)com>, Josh Berkus <josh(at)agliodbs(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Sun Fire T2000 and PostgreSQL 8.1.3
Date: 2006-04-06 21:55:30
Message-ID: 44358E52.4020706@sun.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Hi Leigh

inline comments

Leigh Dyer wrote:

> Luke Lonergan wrote:
>
>> Juan,
>
> We've got a Sun Fire V40z and it's quite a nice machine -- 6x 15krpm
> drives, 4GB RAM, and a pair of Opteron 850s. This gives us more than
> enough power now for what we need, but it's nice to know that we can
> shoehorn a lot more RAM, and up it to eight CPU cores if needed.
>
> The newer Sun Opteron systems look nice too, but unless you're using
> external storage, their little 2.5" hard drives may not be ideal.
>

Thats because Sun Fire V40z had write cache turned on while the
4200/4100 has the write cache turned off. There is a religious belief
around the "write cache" on the disk in Sun :-) To really compare the
performance, you have to turn on the write cache (I believe it was
format -e and the cache option.. but that could have changed.. need to
verify that again.. Same goes for T2000 SAS disks too.. Write cache is
turned off on it so be careful before you compare benchmarks on internal
drives :-)

-Jignesh

> Thanks
> Leigh
>
>>
>> - Luke
>>
>>
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 2: Don't 'kill -9' the postmaster
>>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jignesh K. Shah 2006-04-06 22:13:07 Re: Sun Fire T2000 and PostgreSQL 8.1.3
Previous Message John DeSoi 2006-04-06 17:11:33 Re: CURSOR OR OFFSET/LIMIT