On Wed, 2012-05-23 at 14:37 -0700, Lists wrote: > I'm wondering if there are particular performance bottlenecks we > should be aware of as we scale the hardware up? Does > PG handle 64 GB of RAM well? 128 GB? 16 cores? 48 cores? SAS/SATA III > with SSDs? (etc.) These are not "extreme" for PostgreSQL. PostgreSQL 9.2 will be able to scale up to 64 cores. I know a 9.1 installation that runs on a 48-core machine. It also depends on the application behavior, though. More RAM is nice, and if you can fit your data to the RAM, you will feel more comfortable. For details about SSD, please look at pgsql-performance archives. You will see lots of posts there (or just search for posts from Greg Smith, it will be a shortcut to the solution) Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachment:
signature.asc
Description: This is a digitally signed message part
