Hi,
Today (and previously) I wished that pgbench had a mechanism to help
create simple random databases. For example, I could create a table
"tenk" and fill it with random stuff like
\setrandom foo 1 10000
insert into foo values (:foo)
Now I have to run this 10000 times or something like that. But I don't
want a transaction for each of those, so I had a desire for something
like this:
begin;
\for iterator 1 10000
\setrandom foo 1 :iterator
insert into foo values (:foo);
\end
commit;
Would something like this be acceptable?
--
Álvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>