Re: Postgresql on an AMD64 machine - Mailing list pgsql-performance

From Joshua D. Drake
Subject Re: Postgresql on an AMD64 machine
Date
Msg-id 42A6034A.90405@commandprompt.com
Whole thread Raw
In response to Re: Postgresql on an AMD64 machine  (Donald Courtney <Donald.Courtney@Sun.COM>)
Responses Re: Postgresql on an AMD64 machine
List 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/

pgsql-performance by date:

Previous
From: Donald Courtney
Date:
Subject: Re: Postgresql on an AMD64 machine
Next
From: Tom Arthurs
Date:
Subject: Re: Postgresql on an AMD64 machine