Re: [HACKERS] PgBench's \setrandom could be better

2014-11-17 Thread Robert Haas
On Sat, Nov 15, 2014 at 5:51 PM, David Rowley wrote: > With pgbench I can do: > > \setrandom qty 24 25 > then throw a :qty into the query and have pgbench replace that with either > 24 or 25. > > The problem is that this does not work for anything apart from integer > types. I've got a pending pa

[HACKERS] PgBench's \setrandom could be better

2014-11-15 Thread David Rowley
Hi, I've just been looking into the TPC-H benchmark with intention to put together some scripts which can be run easily to output some run times for each of the 22 queries. I've not had a great deal of exposure to pgbench yet, but I had thought that it might be able to help me run these queries w