From: Joshua D. Drake <jd@commandprompt.com>
To: Xiaoning Ding <dingxn@cse.ohio-state.edu>
Cc: Scott Marlowe <smarlowe@g2switchworks.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: scalablility problem
Date: Sat, 31 Mar 2007 08:49:01 -0700
Message-ID: <460E82ED.8070106@commandprompt.com> (raw)
In-Reply-To: <460E8198.1010604@cse.ohio-state.edu>
References: <460D7220.9010302@cse.ohio-state.edu>
<1175290903.25022.110.camel@state.g2switchworks.com>
<460E8198.1010604@cse.ohio-state.edu>
>> pgsql 7.3 cannot take advantage of lots of shared memory, and has some
>> issues scaling to lots of CPUs / processes.
>
> I use RHEL 4. I can not understand how the scalability related with
> shared memory?
It isn't RHEL4 and shared memory. It is PostgreSQL and shared memory.
Things have changed with PostgreSQL since 7.3 (7.3 is really god awful
old) that allow it to more effectively access shared memory and thus
provide better performance.
Joshua D. Drake
--
=== The PostgreSQL Company: Command Prompt, Inc. ===
Sales/Support: +1.503.667.4564 || 24x7/Emergency: +1.800.492.2240
Providing the most comprehensive PostgreSQL solutions since 1997
http://www.commandprompt.com/
Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate
PostgreSQL Replication: http://www.commandprompt.com/products/
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, dingxn@cse.ohio-state.edu, smarlowe@g2switchworks.com
Subject: Re: scalablility problem
In-Reply-To: <460E82ED.8070106@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