Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization

Поиск
Список
Период
Сортировка
Искать
От
Fabien COELHO
Тема
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization
Дата
Msg-id
alpine.DEB.2.20.1709010921490.15423@lancre
Ответ на
Список
Дерево обсуждения
[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 Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Tatsuo Ishii <ishii@sraoss.co.jp>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Robert Haas <robertmhaas@gmail.com>
Re: [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 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [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 Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [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 Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization Fabien COELHO <coelho@cri.ensmp.fr>
Re: [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 Michael Paquier <michael.paquier@gmail.com>
Re: [HACKERS] pgbench: Skipping the creating primary keys after initialization Masahiko Sawada <sawada.mshk@gmail.com>

Hello Masahiko-san,

Patch applies and compiles.

One bug found, and some minor points again. Sorry for this hopefully last 
iteration... I'm kind of an iterative person...

I've generated the doc to look a it.

Short option "-I" does not use a "=", it should be "-I 
custom_init_commands".

Also maybe it would look nicer and clearer if the short mnemonic was 
outside the literal, that is with:
  c</> (cleanup)</>

instead of:
  c (cleanup)</></>

But this is debatable. Do it the way you think is best.

Command "g" does not work after "f", something I had not tested before:
 ./pgbench -i -I ctvpfg cleaning up... creating tables... vacuum... set primary keys... set foreign keys... ERROR:  cannot truncate a table referenced in a foreign key constraint DETAIL:  Table "pgbench_history" references "pgbench_accounts". HINT:  Truncate table "pgbench_history" at the same time, or use TRUNCATE ... CASCADE.

I think it should work. It probably just mean to TRUNCATE all tables as 
one command, or add the suggested CASCADE. I would favor the first option.

I'm wondering whether this truncation should be yet another available 
command? Hmmm... maybe not.

-- 
Fabien.


В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Masahiko Sawada
Дата:
FAQ