Re: pgbench post-connection command
Alvaro Herrera <alvherre@commandprompt.com>
From: Alvaro Herrera <alvherre@commandprompt.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Simon Riggs <simon@2ndquadrant.com>, Pg Hackers <pgsql-hackers@postgresql.org>
Date: 2012-01-12T15:49:16Z
Lists: pgsql-hackers
Excerpts from Tom Lane's message of jue ene 12 12:26:49 -0300 2012: > Simon Riggs <simon@2ndQuadrant.com> writes: > > New -x option for pgbench executes the given command once after > > connection of each session. > > This seems rather poorly designed, mainly because there's no reason to > think that a single command would be sufficient. > > What would make more sense to me is to add an option for a one-time > script, or possibly extend the script language to allow marking some > commands as "do once". Maybe use isolation tester spec files as examples, which has blocks for a "setup" as well as "teardown", in addition to whatever commands are to run. It's possible that teardown is not ever necessary -- who knows? -- Álvaro Herrera <alvherre@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support