Re: vacuum analyze again... - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: vacuum analyze again...
Date
Msg-id Pine.LNX.4.30.0102201900510.938-100000@peter.localdomain
Whole thread Raw
In response to Re: vacuum analyze again...  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: vacuum analyze again...  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Bruce Momjian writes:

> No, we have no ability to randomly pick rows to use for estimating
> statistics.  Should we have this ability?

How's reading a sufficiently large fraction of random rows going to be
significantly faster than reading all rows?  If you're just going to read
the first n rows then that isn't really random, is it?

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Re: A How-To: PostgreSQL from Tcl via ODBC
Next
From: Tressens Lionel
Date:
Subject: Problems when dumping a database