| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Chittenden | 2004-10-15 20:16:27 | Re: First set of OSDL Shared Mem scalability results, some wierdness ... |
| Previous Message | Josh Berkus | 2004-10-15 19:44:52 | Re: [Testperf-general] Re: First set of OSDL Shared Memscalability results, some wierdness ... |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sean Chittenden | 2004-10-15 20:16:27 | Re: First set of OSDL Shared Mem scalability results, some wierdness ... |
| Previous Message | Sean Chittenden | 2004-10-15 20:09:01 | Re: mmap (was First set of OSDL Shared Mem scalability results, some wierdness ... |