On 2007-03-30, Peter Schuller <[EMAIL PROTECTED]> wrote:
[...]
> Other than absolute performance, an important goal is to be able to
> scale fairly linearly with the number of underlying disk drives. We
> are fully willing to take a disk seek per item selected, as long as it
> scales.
>
> To this e
Tom Lane wrote:
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
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) t
"Joshua D. Drake" <[EMAIL PROTECTED]> writes:
>> 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 all
On Mar 30, 2007, at 4:46 PM, Josh Berkus wrote:
Erik,
You'er welcome! However, I believe our situation is very different
from what you're testing if I understand you correctly. Are you
saying that you're entire database will fit in memory? If so, then
these are very different situations as
Michael Stone wrote:
On Fri, Mar 30, 2007 at 10:00:30PM -0600, Guido Neitzer wrote:
On 30.03.2007, at 19:18, Christopher Browne wrote:
2. There are known issues with the combination of Xeon processors and
PAE memory addressing; that sort of hardware tends to be *way* less
speedy than the specs
Christopher Browne wrote:
Quoth [EMAIL PROTECTED] (Xiaoning Ding):
When I run multiple TPC-H queries (DBT3) on postgresql, I found the system
is not scalable. My machine has 8GB memory, and 4 Xeon Dual Core processor
( 8 cores in total). OS kernel is linux 2.6.9. Postgresql is 7.3.18. I
I t
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 wi
Scott Marlowe wrote:
On Fri, 2007-03-30 at 15:25, Xiaoning Ding wrote:
Hi all,
When I run multiple TPC-H queries (DBT3) on postgresql, I found the system
is not scalable. My machine has 8GB memory, and 4 Xeon Dual Core processor
( 8 cores in total). OS kernel is linux 2.6.9. Postgresql is 7.3
On Fri, Mar 30, 2007 at 10:00:30PM -0600, Guido Neitzer wrote:
On 30.03.2007, at 19:18, Christopher Browne wrote:
2. There are known issues with the combination of Xeon processors and
PAE memory addressing; that sort of hardware tends to be *way* less
speedy than the specs would suggest.
That
