Postgres Pro
Downloads
Home   >   mailing lists

Re: raising the default default_statistics_target - Mailing list pgsql-hackers

From Tom Lane
Subject Re: raising the default default_statistics_target
Date
Msg-id 14456.1078771073@sss.pgh.pa.us
Whole thread Raw
In response to Re: raising the default default_statistics_target  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: raising the default default_statistics_target  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Do all the columns have to have the same number of statistics buckets? 

They do not, but the effort spent by ANALYZE is proportional to the
largest stats target among all the columns of the table.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: raising the default default_statistics_target
Next
From: markw@osdl.org
Date:
Subject: Re: raising the default default_statistics_target