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

From Bruce Momjian
Subject Re: vacuum analyze again...
Date
Msg-id 200102211620.LAA19132@candle.pha.pa.us
Whole thread Raw
In response to Re: vacuum analyze again...  (Pete Forman <pete.forman@westerngeco.com>)
List pgsql-general
>  > Added to TODO:
>  >
>  >         * Allow ANALYZE to process a certain random precentage of
>  >           rows
>
> Does this reduced analysis need to be random?  Why not allow the DBA
> to specify what rows or blocks to do in some way.

No, we are not about to add the kitchen sink here.  If you really want
to control the statistics values, just update pg_attribute and
pg_statistics.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

pgsql-general by date:

Previous
From: Dan Lyke
Date:
Subject: Re: Bug in my ( newbie ) mind?
Next
From: Dan Lyke
Date:
Subject: How to release SET() in PgSQL?