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
Ответ на
Список
Дерево обсуждения
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 по дате отправления
От: John Naylor
Дата:
От: Michael Paquier
Дата:
FAQ