Thread

1. Postgresql & 64 Bit Opteron

   Ericson Smith <eric@did-it.com> — 2004-01-06T19:17:22Z

   Hi,
   
   We're thinking of moving to a 64 bit platform for our database. Does 
   anyone have any stories of migration from 32 bit to 64 bits?
   * How did it impact performance?
   * Were there any gochas?
   * What processors were used (any AMD Opteron's so far?)
   
   Also what kind of performance increase could we expect if we moved from 
   a dual 32 bit to a quad 32 bit platform. (We are already using speedy 
   10,000 RPM SCSI disks in RAID configuration, with gobs of RAM.)
   
   -- 
   Warmest regards, 
   Ericson Smith
   Tracking Specialist/DBA
   +-----------------------+--------------------------------------+
   | http://www.did-it.com | "Crush my enemies, see then driven   |
   | eric@did-it.com       | before me, and hear the lamentations |
   | 516-255-0500          | of their women." - Conan             |
   +-----------------------+--------------------------------------+ 
   
   

2. Re: Postgresql & 64 Bit Opteron

   Joshua D. Drake <jd@commandprompt.com> — 2004-01-06T20:13:47Z

   Hello,
   
     It depends entirely on many different issues. There are a couple of 
   real benefits you will get from the Opteron but only
   if you actually need them.
   
     1. Throughput. The Opteron FSB is the same speed as the chip itself.
     2. Addressable memory (1 TB I believe).
   
      However, generally the number one culprit in performance for a 
   database is IO... Adding more hard drives will help
   (generally speaking) than anything else. Of course that is assuming you 
   have enough RAM.
   
     The other thing to remember is that you will need to run 7.4 to get 
   Opteron support so you may have actual database
   migration issues if you are running 7.3 or previous.
   
   Sincerely,
   
   Joshua D. Drake
   
   
   Ericson Smith wrote:
   
   > Hi,
   >
   > We're thinking of moving to a 64 bit platform for our database. Does 
   > anyone have any stories of migration from 32 bit to 64 bits?
   > * How did it impact performance?
   > * Were there any gochas?
   > * What processors were used (any AMD Opteron's so far?)
   >
   > Also what kind of performance increase could we expect if we moved 
   > from a dual 32 bit to a quad 32 bit platform. (We are already using 
   > speedy 10,000 RPM SCSI disks in RAID configuration, with gobs of RAM.)
   >
   >------------------------------------------------------------------------
   >
   >
   >---------------------------(end of broadcast)---------------------------
   >TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
   >  
   >
   
   
   -- 
   Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
   Postgresql support, programming shared hosting and dedicated hosting.
   +1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
   Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org