Re: First set of OSDL Shared Mem scalability results, some

Matthew T. O'Connor <matthew@zeut.net>

From: Matthew <matthew@zeut.net>
To: Christopher Browne <cbbrowne@acm.org>
Cc: pgsql-performance@postgresql.org
Date: 2004-10-09T15:02:09Z
Lists: pgsql-hackers, pgsql-performance
Christopher Browne wrote:

>josh@agliodbs.com (Josh Berkus) wrote:
>  
>
>>This result is so surprising that I want people to take a look at it
>>and tell me if there's something wrong with the tests or some
>>bottlenecking factor that I've not seen.
>>    
>>
>I'm aware of two conspicuous scenarios where ARC would be expected to
>_substantially_ improve performance:
>
> 1.  When it allows a VACUUM not to throw useful data out of 
>     the shared cache in that VACUUM now only 'chews' on one
>     page of the cache;
>

Right, Josh, I assume you didn't run these test with pg_autovacuum 
running, which might be interesting. 

Also how do these numbers compare to 7.4?   They may not be what you 
expected, but they might still be an improvment.

Matthew