Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization
От | Robert Haas |
---|---|
Тема | Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization |
Дата | |
Msg-id | CA+TgmoboLBOGDxoj5YEZNUpGVwsmj779taEg_ec_5NDJDJ=8xQ@mail.gmail.com обсуждение исходный текст |
Ответ на | [HACKERS] pgbench: Skipping the creating primary keys after initialization (Masahiko Sawada <sawada.mshk@gmail.com>) |
Ответы |
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization |
Список | pgsql-hackers |
On Tue, Aug 1, 2017 at 9:49 PM, Masahiko Sawada <sawada.mshk@gmail.com> wrote: > I'd like to propose a new option -I for pgbench command which skips > the creating primary keys after initialized tables. This option is > useful for users who want to do bench marking with no index or indexes > other than btree primary index. If we initialize pgbench tables at a > large number scale factor the primary key index creation takes a long > time even if we're going to use other types of indexes. With this > option, the initialization time is reduced and you can create indexes > as you want. > > Feedback is very welcome. I'll add this patch to the next CF. I support adding an option for this, but I propose that we just make it a long-form option, similar to --log-prefix or --index-tablespace. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
В списке pgsql-hackers по дате отправления: