meaning of default_statistics_target

From: Martin Marques <martin(at)marquesminen(dot)com(dot)ar>
To: pgsql-general(at)postgresql(dot)org
Subject: meaning of default_statistics_target
Date: 2008-04-28 12:27:17
Message-ID: 4815C2A5.4050300@marquesminen.com.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pascal Cohen 2008-04-28 13:55:36 varchar or text
Previous Message Xavier Eric Moura klausener 2008-04-28 03:03:22 Re: Postgresql installation - cannot initdb 1