От: Tom Lane
Тема: Re: speed of querry?
Дата: ,
Msg-id: 1428.1113495647@sss.pgh.pa.us
(см: обсуждение, исходный текст)
Ответ на: Re: speed of querry?  (Dawid Kuroczko)
Ответы: Re: speed of querry?  ("Joel Fradkin")
Список: pgsql-performance

Скрыть дерево обсуждения

speed of querry?  ("Joel Fradkin", )
 Re: speed of querry?  (Richard Huxton, )
  Re: speed of querry?  ("Joel Fradkin", )
  Re: speed of querry?  (Tom Lane, )
   Re: speed of querry?  ("Joel Fradkin", )
    Re: speed of querry?  (Dawid Kuroczko, )
     Re: speed of querry?  ("Joel Fradkin", )
      Re: speed of querry?  (Dawid Kuroczko, )
       Re: speed of querry?  (Tom Lane, )
        Re: speed of querry?  ("Joel Fradkin", )
         Re: speed of querry?  ("Joel Fradkin", )
 Re: speed of querry?  ("Dave Held", )
  Re: speed of querry?  ("Joel Fradkin", )
   Re: speed of querry?  (Tom Lane, )
    Re: speed of querry?  ("Joel Fradkin", )
     Re: speed of querry?  (Tom Lane, )
 Re: speed of querry?  ("Dave Page", )
  Re: speed of querry?  ("Joel Fradkin", )

Dawid Kuroczko <> writes:
> Basically it tells postgres how many values should it keep for
> statistics per column.  The config default_statistics_target
> is the default (= used when creating table) and ALTER... is
> a way to change it later.

Not quite.  default_statistics_target is the value used by ANALYZE for
any column that hasn't had an explicit ALTER SET STATISTICS done on it.
So you can change default_statistics_target and that will affect
existing tables.

(It used to work the way you are saying, but that was a few releases
back...)

            regards, tom lane


В списке pgsql-performance по дате сообщения:

От: "Dave Held"
Дата:
Сообщение: Re: speed of querry?
От: Alex Turner
Дата:
Сообщение: Re: Intel SRCS16 SATA raid?