From: Reydan Cankur <reydan.cankur@gmail.com>
To: pgsql-performance@postgresql.org
Subject: PostgreSQL on SMP Architectures
Date: Sun, 14 Feb 2010 18:36:24 +0200
Message-ID: <4DA8D3EC-9868-4A6D-8806-F0534C55D2C6@gmail.com> (raw)
Hi,
I have seen some work done about scaling PostgreSQL on SMP machines
and see that PostgreSQL has been executed on several numbers of cores.
I have some questions about scaling PostgreSQL on SMP architectures.
System Details that I am running PostgreSQL-8.4.0:
Server: HP Integrity Superdome SD32B
Processor: Intel Itanium2 1.6 GHz (dual-core)
Number of processors: 32
Number of compute cores: 64
Memory architecture: Shared
Memory amount: 128 GB
Disk amount: 4.6 TB
High performance network: InfiniBand 20 Gbps
Operating system: RHEL 5.1 IA64
Question 1) How can I run PostgreSQL on 2,4,8,16,32 and 64 cores and
get performance results?
I have seen some work about scaling POstgreSQL on SMP architectures
and in these slides there were performance results for PostgreSQL
running on different number of cpu cores. I want to execute PostgreSQL
for different number of cpu cores like 2,4,8,16,32,64 on above server.
But I do not know how to compile or run PostgreSQL on multiple cpu
cores. What is the exact command to tell Postgres to run on specified
number of cores? I need to run Postgres on multiple CPU cores and
document this work.
Question 2)Are there any official benchmarks for PostgreSQL
performance measurements?
I mean when someone wants to run an official performance test on
PostgreSQL which queries and tables must be used. I have executed my
queries on a 5 million record table in order to measure performance,
but I also want to use the official methods.
Question 3) How can I change the allocated memory and measure the
performance of PostgreSQL?
Thanks for all answers,
Reydan
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: reydan.cankur@gmail.com
Subject: Re: PostgreSQL on SMP Architectures
In-Reply-To: <4DA8D3EC-9868-4A6D-8806-F0534C55D2C6@gmail.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