Re: Partitioned tables and covering indexes

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: Partitioned tables and covering indexes
Дата
Msg-id b98d448b-89a3-05f5-65bb-e2f590bff572@sigaev.ru
обсуждение исходный текст
Ответ на Re: Partitioned tables and covering indexes  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Ответы Re: Partitioned tables and covering indexes  (Teodor Sigaev <teodor@sigaev.ru>)
Список pgsql-hackers
Thank you, pushed

Amit Langote wrote:
> Hi.
> 
> On 2018/04/11 0:36, Teodor Sigaev wrote:
>>>      Does the attached fix look correct?  Haven't checked the fix with
>>> ATTACH
>>>      PARTITION though.
>>>
>>>
>>> Attached patch seems to fix the problem.  However, I would rather get
>>> rid of modifying stmt->indexParams.  That seems to be more logical
>>> for me.  Also, it would be good to check some covering indexes on
>>> partitioned tables.  See the attached patch.
>>
>> Seems right way, do not modify incoming object and do not copy rather
>> large and deep nested structure as suggested by Amit.
> 
> Yeah, Alexander's suggested way of using a separate variable for
> indexParams is better.
> 
>> But it will  be better to have a ATTACH PARTITION test too.
> 
> I have added tests.  Actually, instead of modifying existing tests, I
> think it might be better to have a separate section at the end of
> indexing.sql to test covering indexes feature for partitioned tables.
> 
> Attached find updated patch.
> 
> Thanks,
> Amit
> 

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
                                                    WWW: http://www.sigaev.ru/


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

Предыдущее
От: "Jonathan S. Katz"
Дата:
Сообщение: Re: Boolean partitions syntax
Следующее
От: Ashutosh Bapat
Дата:
Сообщение: Re: Creation of wiki page for open items of v11