Re: list of extended statistics on psql
От
Tatsuro Yamada
Тема
Re: list of extended statistics on psql
Дата
Msg-id
0ab933af-ecb5-b1f7-b79f-6a56b563f6a5@nttcom.co.jp_1
Ответ на
Re: list of extended statistics on psql (Julien Rouhaud)
Список
Дерево обсуждения
list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Pavel Stehule <pavel.stehule@gmail.com>
Re: list of extended statistics on psql Julien Rouhaud <rjuju123@gmail.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Julien Rouhaud <rjuju123@gmail.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Alvaro Herrera <alvherre@2ndquadrant.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Alvaro Herrera <alvherre@2ndquadrant.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Alvaro Herrera <alvherre@2ndquadrant.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Alvaro Herrera <alvherre@2ndquadrant.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Alvaro Herrera <alvherre@2ndquadrant.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Alvaro Herrera <alvherre@2ndquadrant.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Pavel Stehule <pavel.stehule@gmail.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Michael Paquier <michael@paquier.xyz>
Re: list of extended statistics on psql Michael Paquier <michael@paquier.xyz>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Alvaro Herrera <alvherre@2ndquadrant.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Julien Rouhaud <rjuju123@gmail.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
RE: list of extended statistics on psql "Shinoda, Noriyoshi (PN Japan FSIP)" <noriyoshi.shinoda@hpe.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Justin Pryzby <pryzby@telsasoft.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@enterprisedb.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: [spam] Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tom Lane <tgl@sss.pgh.pa.us>
Re: list of extended statistics on psql Tomas Vondra <tomas.vondra@2ndquadrant.com>
Re: list of extended statistics on psql Tom Lane <tgl@sss.pgh.pa.us>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Re: list of extended statistics on psql Tatsuro Yamada <tatsuro.yamada.tf@nttcom.co.jp>
Hi!
>> +1 good idea
>
> +1 that's a good idea. Please add it to the next commitfest!
Thanks!
> You have a typo:
>
> + if (pset.sversion < 10000)
> + {
> + char sverbuf[32];
> +
> + pg_log_error("The server (version %s) does not support
> extended statistics.",
> + formatPGVersionNumber(pset.sversion, false,
> + sverbuf, sizeof(sverbuf)));
> + return true;
> + }
>
> the version test is missing a 0, the feature looks otherwise ok.
Ouch, I fixed on the attached patch.
The new patch includes:
- Fix the version number check (10000 -> 100000)
- Fix query to get extended stats info for sort order
- Add handling [Pattern] e.g \dz stts*
- Add document and regression test for \dz
> How about using \dX rather than \dz?
Thanks for your suggestion!
I'll replace it if I got consensus. :-D
Thanks,
Tatsuro Yamada
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата: