From: | Reydan Cankur <reydan(dot)cankur(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | PostgreSQL on SMP Architectures |
Date: | 2010-02-14 16:36:24 |
Message-ID: | 4DA8D3EC-9868-4A6D-8806-F0534C55D2C6@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2010-02-14 17:11:39 | Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) |
Previous Message | Greg Stark | 2010-02-14 15:31:58 | Re: Re: Faster CREATE DATABASE by delaying fsync (was 8.4.1 ubuntu karmic slow createdb) |