Re: Test lab

From: Greg Smith <gsmith(at)gregsmith(dot)com>
To:
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Test lab
Date: 2007-11-09 14:49:54
Message-ID: Pine.GSO.4.64.0711090931470.1537@westnet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Sun, 4 Nov 2007, Stefan Kaltenbrunner wrote:

>> I never got the database tests in SysBench to produce useful results
>> [because of deadlocks]
>
> hmm I have not seen that and the recent freebsd related scalability
> benchmarks(http://people.freebsd.org/~kris/scaling/) seem to indicate
> that it seems to work quite well at least for some stuff.

After digesting those, I note that the FreeBSD tests were using
--oltp-read-only which doesn't do any database writes--so no ROW EXCLUSIVE
locks either. I was using things like the "complex" setting, and it was
the UPDATE statements in there that didn't work right when I last tested.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD

In response to

  • Re: Test lab at 2007-11-04 19:01:33 from Stefan Kaltenbrunner

Browse pgsql-hackers by date

  From Date Subject
Next Message Zdenek Kotala 2007-11-09 14:55:15 Re: Feature request concerning postmaster log file.
Previous Message Andrew Dunstan 2007-11-09 14:30:01 Re: Feature request concerning postmaster log file.