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 <alvhe...@alvh.no-ip.org> -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
