public inbox for [email protected]  

help / color / mirror / Atom feed

From: Martijn van Oosterhout <[email protected]>
To: Tom Lane <[email protected]>
Cc: Jim C. Nasby <[email protected]>
Cc: David Fetter <[email protected]>
Cc: Scott Marlowe <[email protected]>
Cc: Jason McManus <[email protected]>
Cc: pgsql general <[email protected]>
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Date: Sat, 1 Jul 2006 14:09:40 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>
	<[email protected]>

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,
-- 
Martijn van Oosterhout   <[email protected]>   http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.


Attachments:

  [application/pgp-signature] signature.asc (189B, 2-signature.asc)
  download

view thread (38+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox