From: Jignesh K. Shah <J.K.Shah@Sun.COM>
To: Gregory Stark <stark@enterprisedb.com>
Cc: decibel <decibel@decibel.org>
Cc: pgsql-performance@postgresql.org <pgsql-performance@postgresql.org>
Subject: Re: Proposal of tunable fix for scalability of 8.4
Date: Mon, 16 Mar 2009 15:39:20 -0400
Message-ID: <49BEAAE8.4010402@sun.com> (raw)
In-Reply-To: <87fxhd33qb.fsf@oxford.xeocode.com>
References: <C5DEE151.33BA%scott@richrelevance.com>
<49BA53CF.4020702@sun.com>
<49BA742D.3050203@sun.com>
<49BA8CF6.6090604@sun.com>
<49BABBCE.8090501@sun.com>
<D4B5954C-4E01-40B7-BC6E-F98842593889@decibel.org>
<49BD6840.4000403@sun.com>
<87fxhd33qb.fsf@oxford.xeocode.com>
On 03/16/09 11:08, Gregory Stark wrote:
> "Jignesh K. Shah" <J.K.Shah@Sun.COM> writes:
>
>
>> Generally when there is dead constant.. signs of classic bottleneck ;-) We
>> will be fixing one to get to another.. but knocking bottlenecks is the name of
>> the game I think
>>
>
> Indeed. I think the bottleneck we're interested in addressing here is why you
> say you weren't able to saturate the 64 threads with 64 processes when they're
> all RAM-resident.
>
> From what I see you still have 400+ processes? Is that right?
>
>
Any one claiming they run CPU intensive are not always telling the
truth.. They *Think* they are running CPU intensive for the right part
but there could be memory misses, they could be doing statistics where
they are not really stressing the intended stuff to test, they could be
parsing through the results where they are not stressing the backend
while still claiming to be cpu intensive (though from a different
perspective)
So yes a single process specially a client cannot claim to keep the
backend 100% active but so can neither a connection pooler since it
still has to some other stuff within the process.
-Jignesh
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: J.K.Shah@Sun.COM, stark@enterprisedb.com, decibel@decibel.org
Subject: Re: Proposal of tunable fix for scalability of 8.4
In-Reply-To: <49BEAAE8.4010402@sun.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