Sorry I forgot to attach the the patch. Regards,
Michael On Fri, Aug 7, 2009 at 12:23 PM, Michael Paquier <michael.paqu...@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
postgresql-8.4.0-pgbenchshell.patch
Description: Binary data
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers