Re: Postgresql on an AMD64 machine

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Donald Courtney <Donald(dot)Courtney(at)Sun(dot)COM>
Cc: Tom Arthurs <tarthurs(at)jobflash(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: Postgresql on an AMD64 machine
Date: 2005-06-07 20:27:54
Message-ID: 42A6034A.90405@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

>>
> The system has 8 CPUs w/ 32 GB - I'm hoping to see some benefit to large
> caches -
> Am I missing something key with postgreSQL?
> Yes - we have seen with oracle 64 bit that there can be as much as a 10%
> hit moving
> from 32 - but we make it up big time with large db-buffer sizes that
> drastically

Well for Opteron you should also gain from the very high memory
bandwidth and the fact that it has I believe "3" FP units per CPU.

Sincerely,

Joshua D. Drake
--
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Alvaro Herrera 2005-06-07 20:27:55 Re: Postgresql on an AMD64 machine
Previous Message Donald Courtney 2005-06-07 20:19:24 Re: Postgresql on an AMD64 machine