Re: Using multiple extended statistics for estimates

Поиск
Список
Период
Сортировка
От Mark Dilger
Тема Re: Using multiple extended statistics for estimates
Дата
Msg-id 0ff3bd5d-33a7-6283-1a80-91d1df5c988c@gmail.com
обсуждение исходный текст
Ответ на Re: Using multiple extended statistics for estimates  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Ответы Re: Using multiple extended statistics for estimates  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Список pgsql-hackers

On 12/9/19 2:00 PM, Tomas Vondra wrote:
>>
>> These look good to me.  I added extra tests (not included in this email)
>> to verify the code on more interesting test cases, such as partitioned
>> tables and within joins.  Your test cases are pretty trivial, just being
>> selects from a single table.
>>
> 
> Adding such more complex tests seem like a good idea, maybe you'd like
> to share them?

You can find them attached.  I did not include them in my earlier email
because they seem a bit unrefined, taking too many lines of code for the
amount of coverage they provide.  But you can prune them down and add
them to the patch if you like.

These only test the functional dependencies.  If you want to include
something like them in your commit, you might create similar tests for
the mcv statistics, too.

-- 
Mark Dilger

Вложения

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

Предыдущее
От: Kyotaro Horiguchi
Дата:
Сообщение: Re: xact_start for walsender & logical decoding not updated
Следующее
От: Andres Freund
Дата:
Сообщение: A varint implementation for PG?