X-Original-To: pgsql-general-postgresql.org@postgresql.org
Received: from localhost (mx1.hub.org [200.46.208.251])
	by postgresql.org (Postfix) with ESMTP id A83E89FA395
	for <pgsql-general-postgresql.org@postgresql.org>;
	Sat,  1 Jul 2006 09:10:20 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
	with ESMTP id 13407-02 for
	<pgsql-general-postgresql.org@postgresql.org>;
	Sat,  1 Jul 2006 09:10:11 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-
Received: from svana.org (svana.org [125.62.94.225])
	by postgresql.org (Postfix) with ESMTP id C7E329FA140
	for <pgsql-general@postgresql.org>;
	Sat,  1 Jul 2006 09:10:10 -0300 (ADT)
Received: from kleptog by svana.org with local (Exim 4.50)
	id 1FweI8-0006We-Hq; Sat, 01 Jul 2006 22:09:40 +1000
Date: Sat, 1 Jul 2006 14:09:40 +0200
From: Martijn van Oosterhout <kleptog@svana.org>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: "Jim C. Nasby" <jnasby@pervasive.com>, David Fetter <david@fetter.org>,
	Scott Marlowe <smarlowe@g2switchworks.com>,
	Jason McManus <mcmanus.jason@gmail.com>,
	pgsql general <pgsql-general@postgresql.org>
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Message-ID: <20060701120940.GB24775@svana.org>
Reply-To: Martijn van Oosterhout <kleptog@svana.org>
Mail-Followup-To: Tom Lane <tgl@sss.pgh.pa.us>,
	"Jim C. Nasby" <jnasby@pervasive.com>,
	David Fetter <david@fetter.org>,
	Scott Marlowe <smarlowe@g2switchworks.com>,
	Jason McManus <mcmanus.jason@gmail.com>,
	pgsql general <pgsql-general@postgresql.org>
References: <b0f0a0e00606300617j2ed6dd4cub7bc2db972f6211a@mail.gmail.com>
	<1151680333.13129.55.camel@state.g2switchworks.com>
	<24350.1151681944@sss.pgh.pa.us> <20060630173037.GC7035@fetter.org>
	<25395.1151689313@sss.pgh.pa.us> <20060630180119.GD7035@fetter.org>
	<20060701001331.GR17241@pervasive.com>
	<18709.1151724366@sss.pgh.pa.us>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="7ZAtKRhVyVSsbBD2"
Content-Disposition: inline
In-Reply-To: <18709.1151724366@sss.pgh.pa.us>
X-PGP-Key-ID: Length=1024; ID=0x0DC67BE6
X-PGP-Key-Fingerprint: 295F A899 A81A 156D B522  48A7 6394 F08A 0DC6 7BE6
X-PGP-Key-URL: <http://svana.org/kleptog/0DC67BE6.pgp.asc>
User-Agent: Mutt/1.5.9i
X-SA-Exim-Connect-IP: <locally generated>
X-SA-Exim-Mail-From: kleptog@svana.org
X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200607/5
X-Sequence-Number: 97629


--7ZAtKRhVyVSsbBD2
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Jun 30, 2006 at 11:26:06PM -0400, Tom Lane wrote:
> Something that would actually hold some intellectual interest is to
> improve the testing infrastructure.  The current setup is pretty limited
> as to its ability to deal with varying outputs, and even more limited
> in its ability to test concurrent behavior.  Again, see the archives.

I must admit I was kind of surprised this didn't generate much
feedback:

http://archives.postgresql.org/pgsql-hackers/2005-08/msg01073.php

It's a simple tester that drives multiple postgres backends
simultaneously and can test whether various concurrently running
transaction correctly block/abort in various situations. I also used it
to test whether all the different LOCK types work as documented in the
documentation (they do, the program checked all combinations of two
locks).

It would in theory be possible to generate scripts to test thing like
simultaneously firing multiple CREATE INDEX commands in seperate
transactions and see how they interact.

Have a nice day,
--=20
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to l=
itigate.

--7ZAtKRhVyVSsbBD2
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFEpmYEIB7bNG8LQkwRAglGAJ9D/fUj+N3I3zvwdErqil8ytoUVIwCbB3Yg
su89iDmRyv9p+V/ywyYOuOU=
=+ylT
-----END PGP SIGNATURE-----

--7ZAtKRhVyVSsbBD2--