Re: Documentation improvements for partitioning
От | Amit Langote |
---|---|
Тема | Re: Documentation improvements for partitioning |
Дата | |
Msg-id | 80f6b049-e882-f6c3-f82c-f44baa94d369@lab.ntt.co.jp обсуждение исходный текст |
Ответ на | Re: Documentation improvements for partitioning (Robert Haas <robertmhaas@gmail.com>) |
Список | pgsql-hackers |
On 2017/04/01 6:37, Robert Haas wrote: > On Tue, Mar 28, 2017 at 6:35 AM, Amit Langote > <Langote_Amit_f8@lab.ntt.co.jp> wrote: >> Attached updated patch. > > Committed with editing here and there. I just left out the thing > about UNION ALL views, which seemed to brief a treatment to deserve > its own subsection. Maybe a longer explanation of that is worthwhile > or maybe it's not, but that can be a separate patch. Thanks for committing. I noticed what looks like a redundant line (or an incomplete sentence) in the paragraph about multi-column partition keys. In the following text: + partitioning, if desired. Of course, this will often result in a larger + number of partitions, each of which is individually smaller. + criteria. Using fewer columns may lead to coarser-grained + A query accessing the partitioned table will have + to scan fewer partitions if the conditions involve some or all of these This: + criteria. Using fewer columns may lead to coarser-grained looks redundant. But maybe we can keep that sentence by completing it, which the attached patch does as follows: + number of partitions, each of which is individually smaller. On the + other hand, using fewer columns may lead to a coarser-grained + partitioning criteria with smaller number of partitions. The patch also fixes some typos I noticed. Thanks, Amit
Вложения
В списке pgsql-hackers по дате отправления: