Re: Add support for (Var op Var) clause in extended MCV statistics
От | Tomas Vondra |
---|---|
Тема | Re: Add support for (Var op Var) clause in extended MCV statistics |
Дата | |
Msg-id | 73dd8031-b2a0-4ed8-b642-8afb196e6ce8@vondra.me обсуждение исходный текст |
Ответ на | Re: Add support for (Var op Var) clause in extended MCV statistics (Alena Rybakina <a.rybakina@postgrespro.ru>) |
Ответы |
Re: Add support for (Var op Var) clause in extended MCV statistics
|
Список | pgsql-hackers |
On 8/12/24 13:44, Alena Rybakina wrote: > Hi! I think your work is important) > I agree, and I'm grateful someone picked up the original patch. I'll try to help to keep it moving forward. If the thread gets stuck, feel free to ping me to take a look. > I started reviewing it and want to suggest some changes to better code: > I think we should consider the case where the expression is not neither > an OpExpr and VarOpVar expression. > Do you have some specific type of clauses in mind? Most of the extended statistics only really handles this type of clauses, so I'm not sure it's feasible to extend that - at least not in this patch. > Have you tested this code with any benchmarks? > FWIW I think we need to test two things - that it (a) improves the estimates and (b) does not have significant overhead. regards -- Tomas Vondra
В списке pgsql-hackers по дате отправления: