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

From: Mattias Kregert <matti(at)algonet(dot)se>
To: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Re: [QUESTIONS] Business cases
Date: 1998-01-20 12:01:34
Message-ID: 34C4921D.172A4971@algonet.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 */

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mattias Kregert 1998-01-20 13:43:21 Compiling postgresql with profiling
Previous Message Vadim B. Mikheev 1998-01-20 07:11:43 Re: Var->sublevels_up