Re: pg_stats question - Mailing list pgsql-general

From Joseph Shraibman
Subject Re: pg_stats question
Date
Msg-id 3FFC8AFD.2020908@selectacast.net
Whole thread Raw
In response to Re: pg_stats question  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_stats question
List pgsql-general
Tom Lane wrote:
> Joseph Shraibman <jks@selectacast.net> writes:
>
>>I notice in 7.4.1 that if I do:
>>ALTER TABLE <tab> ALTER <col> SET STATISTICS 100;
>>... that not necc. 100 values are stored in pg_stats, but in 7.3.4 it
>>did.  Bug or expected behaviour?
>
>
> It wasn't necessarily 100 values in 7.3, either.
>
> As a trivial counterexample, if you have less than 100 distinct values
> in your column, there definitely won't be 100 values in the
> most-common-values list ...
>


Right, but in this case I'm sure I have over 200 values.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_stats question
Next
From: "Marc G. Fournier"
Date:
Subject: Re: Problem with rserv replication