Tom,
> The files for the updated test case are attached if anyone else wants
> to try it. They are:
I've added you to the "Performance Test"project on Pgfoundry (same login as
GBorg). Could you post the test files and patch there? I can get the
people at Sun to test on Sparc.
You can uploa
Tom Lane wrote:
Anyone have SMP boxes of other types that they can try this on?
For those of us running antiques:
2x PIII 1Ghz 2G
Running on FreeBSD 6.0beta4 (non-debug kernel)
8.0.3:
N runtime: 1 158s 2 271s 4 567s
8.1beta1 (2005-08-28):
N runtime: 1 85s 2 139s 4 220s
Wow - a huge
On Sun, 11 Sep 2005, Tom Lane wrote:
> The files for the updated test case are attached if anyone else wants
> to try it. They are:
>
> test_setup.sql Run this to create the test tables
>
> test_run.sqlA version of the test query that will run
> pretty nearl
I've recently been taking another look at the test case shown here:
http://archives.postgresql.org/pgsql-performance/2004-04/msg00280.php
This is the infamous "context swap storm" problem that we've hacking
at for so long. After the 8.1 buffer manager redesign, the problem
of contention for the Bu
