Re: [HACKERS] Re: [QUESTIONS] Business cases

Поиск
Список
Период
Сортировка
От Mattias Kregert
Тема Re: [HACKERS] Re: [QUESTIONS] Business cases
Дата
Msg-id 34C4921D.172A4971@algonet.se
обсуждение исходный текст
Ответ на Re: Re: [HACKERS] Re: [QUESTIONS] Business cases  (Bruce Momjian <maillist@candle.pha.pa.us>)
Ответы Re: [HACKERS] Re: [QUESTIONS] Business cases  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Bruce Momjian wrote:
>
> > *** Btw, why doesn't PG update statistics when inserting/updating?
>
> Too slow to do at that time.  You need to span all the data to get an
> accurate figure.

Is it not possible to take the current statistics and the latest
changes and calculate new statistics from that?

What information is kept in these statistics? How are they used?
Obviously this is more than just number of rows, but what exactly?

/* m */

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

Предыдущее
От: "Vadim B. Mikheev"
Дата:
Сообщение: Re: Var->sublevels_up
Следующее
От: Mattias Kregert
Дата:
Сообщение: Compiling postgresql with profiling