Re: pgbench - allow to create partitioned tables
От
Fabien COELHO
Тема
Re: pgbench - allow to create partitioned tables
Дата
Msg-id
alpine.DEB.2.21.1909240813280.5923@lancre
Ответ на
Re: pgbench - allow to create partitioned tables (Amit Kapila)
Список
Дерево обсуждения
pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Simon Riggs <simon@2ndquadrant.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Asif Rehman <asifr.rehman@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Asif Rehman <asifr.rehman@gmail.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Erikjan Rijkers <er@xs4all.nl>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Langote <amitlangote09@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Dilip Kumar <dilipbalaut@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Langote <amitlangote09@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Langote <amitlangote09@gmail.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Dilip Kumar <dilipbalaut@gmail.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Rafia Sabih <rafia.pghackers@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Rafia Sabih <rafia.pghackers@gmail.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Ashutosh Sharma <ashu.coek88@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Ashutosh Sharma <ashu.coek88@gmail.com>
Re: pgbench - allow to create partitioned tables Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Amit Kapila <amit.kapila16@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Dilip Kumar <dilipbalaut@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Dilip Kumar <dilipbalaut@gmail.com>
Re: pgbench - allow to create partitioned tables Fabien COELHO <coelho@cri.ensmp.fr>
Re: pgbench - allow to create partitioned tables Dilip Kumar <dilipbalaut@gmail.com>
Hello Amit,
> {...]
> If you agree with this, then why haven't you changed below check in patch:
>
> + if (partition_method != PART_NONE)
> + printf("partition method: %s\npartitions: %d\n",
> + PARTITION_METHOD[partition_method], partitions);
>
> This is exactly the thing bothering me. It won't be easy for others
> to understand why this check for partitioning information is different
> from other checks.
As I tried to explain with an example, using "partitions > 0" does not
work in this case because you can have a partitioned table with zero
partitions attached while benchmarking, but this cannot happen while
creating.
> For you or me, it might be okay as we have discussed this case, but it
> won't be apparent to others. This doesn't buy us much, so it is better
> to keep this code consistent with other places that check for
> partitions.
Attached uses "partition_method != PART_NONE" consistently, plus an assert
on "partitions > 0" for checking and for triggering the default method at
the end of option processing.
--
Fabien.В списке pgsql-hackers по дате отправления
От: Alexey Kondratov
Дата:
От: Nikolay Shaplov
Дата: