From: Tom Arthurs <tarthurs@jobflash.com>
To: Juan Casero <caseroj@comcast.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: Wed, 21 Dec 2005 19:34:00 -0800
Message-ID: <43AA1EA8.40004@jobflash.com> (raw)
In-Reply-To: <200512212209.50234.caseroj@comcast.net>
References: <43A84D03.7090002@ritek.hu>
<200512201950.47671.caseroj@comcast.net>
<docq5v$24ea$1@news.hub.org>
<200512212209.50234.caseroj@comcast.net>
AFAIK there are no licensing costs for solaris, unless you are talking
about a software support agreement, which is not required.
Juan Casero wrote:
>I just sent my boss an email asking him for a Sun v20z with dual 2.2 Ghz
>opterons, 2 Gigs of RAM and RAID 1. I would have liked a better server
>capable of RAID but that seems to be out of his budget right now. Ok so I
>assume I get this Sun box. Most likely I will go with Linux since it is a
>fair bet he doesn't want to pay for the Solaris 10 x86 license. Although I
>kind of like the idea of using Solaris 10 x86 for this. I will assume I
>need to install the x64 kernel that comes with say Fedora Core 4. Should I
>run the Postgresql 8.x binaries in 32 bit mode or 64 bit mode? My instinct
>tells me 64 bit mode is most efficient for our database size about 20 gigs
>right now but may grow to 100 gigs in a year or so. I just finished loading
>a 20 gig database on a dual 900 Mhz Ultrasparc III system with 2 gigs of ram
>and about 768 megs of shared memory available for the posgresql server
>running Solaris 10. The load has smoked a P4 3.2 Ghz system I am using also
>with 2 gigs of ram running postgresql 8.0.3. I mean I started the sparc
>load after the P4 load. The sparc load has finished already rebuilding the
>database from a pg_dump file but the P4 system is still going. The p4 has
>1.3 Gigs of shared memory allocated to postgresql. How about them apples?
>
>
>Thanks,
>Juan
>
>On Wednesday 21 December 2005 18:57, William Yu wrote:
>
>
>>Juan Casero wrote:
>>
>>
>>>Can you elaborate on the reasons the opteron is better than the Xeon when
>>>it comes to disk io? I have a PostgreSQL 7.4.8 box running a DSS. One
>>>of our
>>>
>>>
>>Opterons have 64-bit IOMMU -- Xeons don't. That means in 64-bit mode,
>>transfers to > 4GB, the OS must allocated the memory < 4GB, DMA to that
>>block and then the CPU must do extra work in copying the memory to >
>>4GB. Versus on the Opteron, it's done by the IO adaptor using DMA in the
>>background.
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: explain analyze is your friend
>>
>>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
>
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tarthurs@jobflash.com, caseroj@comcast.net
Subject: Re: What's the best hardver for PostgreSQL 8.1?
In-Reply-To: <43AA1EA8.40004@jobflash.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox