Re: [PATCH] pgbench: new feature allowing to launch shell commands - Mailing list pgsql-hackers

From Michael Paquier
Subject Re: [PATCH] pgbench: new feature allowing to launch shell commands
Date
Msg-id c64c5f8b0908062026p6cd6b710wf1b2b359eb78ff6f@mail.gmail.com
Whole thread Raw
In response to [PATCH] pgbench: new feature allowing to launch shell commands  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [PATCH] pgbench: new feature allowing to launch shell commands  (Robert Haas <robertmhaas@gmail.com>)
Re: [PATCH] pgbench: new feature allowing to launch shell commands  (Itagaki Takahiro <itagaki.takahiro@oss.ntt.co.jp>)
List pgsql-hackers
Sorry I forgot to attach the the patch.
 
Regards,
 
Michael

On Fri, Aug 7, 2009 at 12:23 PM, Michael Paquier <michael.paquier@gmail.com> wrote:
Hi all,
 
Here is a short patch implementing a new feature in pgbench so as to allow shell commands to be launched in a transaction file of pgbench.
the user has just to add at the beginning of the command line in his transaction file \shell + the command wanted.
 
As an example of transaction:
Begin;
[Transaction instructions]
Prepare transaction ‘TXID’;
\shell ls ~/pg_twophase;
Commit prepared ‘TXID’;
 
This patch was particularly useful in order to determine the size of state files flushed to disk for prepared but not committed transactions.
As an addition, I added a new default transaction in the code that permits to launch a 2PC transaction with a random prepare identifier of the format Txxx.
 
I also created a page in postgresql's wiki about this feature.
Please refer to this link: http://wiki.postgresql.org/wiki/Pgbench:_shell_command
 
Regards,

--
Michael Paquier

NTT OSSC



--
Michael Paquier

NTT OSSC
Attachment

pgsql-hackers by date:

Previous
From: Michael Paquier
Date:
Subject: [PATCH] pgbench: new feature allowing to launch shell commands
Next
From: Michael Paquier
Date:
Subject: [PATCH] 2PC state files on shared memory