meaning of default_statistics_target - Mailing list pgsql-general

From Martin Marques
Subject meaning of default_statistics_target
Date
Msg-id 4815C2A5.4050300@marquesminen.com.ar
Whole thread Raw
Responses Re: meaning of default_statistics_target  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
I'm trying to understand the implications of changing the value of the
STATISTICS of a column with ALTER TABLE, and there are somethings I'm
not understanding correctly.

How much, and which extra statistics information will ANALYZE gather if
I set a higher value for one specific column (maybe one with and index,
and heavily used in SELECT clauses)? If instead of 100 I set a column to
250, which extra data will I see in pg_statistics after an ANALYZE?

Thanks.

pgsql-general by date:

Previous
From: Lew
Date:
Subject: Re: timestamp with time zone output incorrect
Next
From: Pascal Cohen
Date:
Subject: varchar or text