Re: pgbench \for or similar loop

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Aidan Van Dyk <aidan(at)highrise(dot)ca>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Christopher Browne <cbbrowne(at)gmail(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgbench \for or similar loop
Date: 2011-04-23 15:10:39
Message-ID: m2liz12ec0.fsf@2ndQuadrant.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Greg Smith <greg(at)2ndquadrant(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2011-04-23 15:37:49 Re: Collation patch's handling of wcstombs/mbstowcs is sheerest fantasy
Previous Message Yves Weißig 2011-04-23 14:05:26 Re: best way to test new index?