Skip site navigation (1) Skip section navigation (2)

Re: What's the best hardver for PostgreSQL 8.1?

From: Tom Arthurs <tarthurs(at)jobflash(dot)com>
To: Juan Casero <caseroj(at)comcast(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: What's the best hardver for PostgreSQL 8.1?
Date: 2005-12-22 03:34:00
Message-ID: 43AA1EA8.40004@jobflash.com (view raw or flat)
Thread:
Lists: pgsql-performance
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(at)postgresql(dot)org so that your
>       message can get through to the mailing list cleanly
>
>
>  
>

In response to

pgsql-performance by date

Next:From: Tom LaneDate: 2005-12-22 03:45:11
Subject: Re: Speed of different procedural language
Previous:From: Luke LonerganDate: 2005-12-22 03:33:14
Subject: Re: MySQL is faster than PgSQL but a large margin in

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group