Re: pgbench -f and vacuum

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: pgbench -f and vacuum
Дата
Msg-id 20141222235517.GI1768@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: pgbench -f and vacuum  (Tatsuo Ishii <ishii@postgresql.org>)
Ответы Re: pgbench -f and vacuum  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Here's a completely different idea.  How about we add an option that
means "vacuum this table before running the test" (can be given several
times); by default the set of vacuumed tables is the current pgbench_*
list, but if -f is specified then the default set is cleared.  So if you
have a -f script and want to vacuum the default tables, you're forced to
give a few --vacuum-table=foo options.  But this gives the option to
vacuum some other table before the test, not just the pgbench default
ones.

This is a bit more complicated, and makes life more difficult to people
using -f and the default pgbench tables than your proposed new -k
switch.  But it's more general and it might have more use cases; and
people using -f with the default pgbench tables are probably rare,
anyway.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: bin checks taking too long.
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: replicating DROP commands across servers