Skip site navigation (1) Skip section navigation (2)

Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>,"Simon Riggs" <simon(at)2ndquadrant(dot)com>,"Timothy D(dot) Witham" <wookie(at)osdl(dot)org>, testperf-general(at)pgfoundry(dot)org
Subject: Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...
Date: 2004-10-15 20:13:13
Message-ID: 200410151313.13624.josh@agliodbs.com (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
Tom, Simon:

First off, two test runs with OProfile are available at:
http://khack.osdl.org/stp/298124/
http://khack.osdl.org/stp/298121/

> AtEOXact_Buffers
>         transaction commit or abort
> UnlockBuffers
>         transaction abort, backend exit

Actually, this might explain the "hump" shape of the curve for this test.  
DBT2 is an OLTP test, which means that (at this scale level) it's attempting 
to do approximately 30 COMMITs per second as well as one ROLLBACK every 3 
seconds.    When I get the tests on DBT3 running, if we see a more gentle 
dropoff on overallocated memory, it would indicate that the above may be a 
factor.

-- 
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

pgsql-performance by date

Next:From: Sean ChittendenDate: 2004-10-15 20:16:27
Subject: Re: First set of OSDL Shared Mem scalability results, some wierdness ...
Previous:From: Sean ChittendenDate: 2004-10-15 20:09:01
Subject: Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ...

pgsql-hackers by date

Next:From: Sean ChittendenDate: 2004-10-15 20:16:27
Subject: Re: First set of OSDL Shared Mem scalability results, some wierdness ...
Previous:From: Josh BerkusDate: 2004-10-15 19:44:52
Subject: Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group