pgbench \for or similar loop

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема pgbench \for or similar loop
Дата
Msg-id 1303159471-sup-2303@alvh.no-ip.org
обсуждение исходный текст
Ответы Re: pgbench \for or similar loop  (Merlin Moncure <mmoncure@gmail.com>)
Re: pgbench \for or similar loop  (David Fetter <david@fetter.org>)
Список 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 по дате отправления:

Предыдущее
От: Dann Corbit
Дата:
Сообщение: Re: ORDER BY 1 COLLATE
Следующее
От: "Kevin Grittner"
Дата:
Сообщение: Re: ORDER BY 1 COLLATE