pgbench \for or similar loop - Mailing list pgsql-hackers

From Alvaro Herrera
Subject pgbench \for or similar loop
Date
Msg-id 1303159471-sup-2303@alvh.no-ip.org
Whole thread Raw
Responses Re: pgbench \for or similar loop
Re: pgbench \for or similar loop
List pgsql-hackers
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 :iteratorinsert into foo values (:foo);
\end
commit;

Would something like this be acceptable?

-- 
Álvaro Herrera <alvherre@alvh.no-ip.org>


pgsql-hackers by date:

Previous
From: Dann Corbit
Date:
Subject: Re: ORDER BY 1 COLLATE
Next
From: "Kevin Grittner"
Date:
Subject: Re: ORDER BY 1 COLLATE