Greg Smith <greg@2ndquadrant.com> writes:
> Kevin Grittner wrote:
>> I'm not clear on exactly what you're proposing there, but the thing
>> I've considered doing is having threads to try to keep a FIFO queue
>> populated with a configurable transaction mix, while a configurable
>> number of worker threads pull those transactions off the queue and...
>
> This is like the beginning of an advertisement for how Tsung is useful for
> simulating complicated workloads. The thought of growing pgbench to reach
> that level of capabilities makes my head hurt.
+1 for having a look at Tsung here. You'll be glad not to have to
reinvent all what it already does.
> When faced with this same issue, the sysbench team decided to embed Lua as
> their scripting language; sample scripts:
I would tend to prefer some scheme (guile comes to the mind but that's
GPL), being an Emacs user. Also I've seen projects pick lua then down
the road regret the choice (http://julien.danjou.info/blog/2008.html).
Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr