Re: [HACKERS] Re: [QUESTIONS] Business cases - Mailing list pgsql-hackers

From Mattias Kregert
Subject Re: [HACKERS] Re: [QUESTIONS] Business cases
Date
Msg-id 34C4921D.172A4971@algonet.se
Whole thread Raw
In response to Re: Re: [HACKERS] Re: [QUESTIONS] Business cases  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] Re: [QUESTIONS] Business cases  (Bruce Momjian <maillist@candle.pha.pa.us>)
List 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 by date:

Previous
From: "Vadim B. Mikheev"
Date:
Subject: Re: Var->sublevels_up
Next
From: Mattias Kregert
Date:
Subject: Compiling postgresql with profiling