From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | [PATCH] pgbench: new feature allowing to launch shell commands |
Date: | 2009-08-07 03:23:38 |
Message-ID: | c64c5f8b0908062023n42319d8bh83186e5602c63e92@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Paquier | 2009-08-07 03:26:45 | Re: [PATCH] pgbench: new feature allowing to launch shell commands |
Previous Message | David E. Wheeler | 2009-08-07 03:12:28 | Re: Re: [Pg-migrator-general] Composite types break pg_migrated tables |