From: Joshua D. Drake <jd@commandprompt.com>
To: Donald Courtney <Donald.Courtney@Sun.COM>
Cc: Tom Arthurs <tarthurs@jobflash.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgresql on an AMD64 machine
Date: Tue, 07 Jun 2005 13:27:54 -0700
Message-ID: <42A6034A.90405@commandprompt.com> (raw)
In-Reply-To: <42A6014C.30108@sun.com>
References: <1118080420.1644.23.camel@penguin1>
<b918cf3d05060613593a73a18a@mail.gmail.com>
<42A5F7B6.20502@sun.com>
<42A5FB70.8090807@jobflash.com>
<42A6014C.30108@sun.com>
>>
> 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/
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: jd@commandprompt.com, Donald.Courtney@Sun.COM, tarthurs@jobflash.com
Subject: Re: Postgresql on an AMD64 machine
In-Reply-To: <42A6034A.90405@commandprompt.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