Analyze and default_statistics_target

From: AJ Weber <aweber(at)comcast(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: Analyze and default_statistics_target
Date: 2013-01-21 15:29:34
Message-ID: 50FD5EDE.8010002@comcast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

I was under the impression that the default_statistics_target was a
percentage of rows to analyze. Maybe this is not the case?

I ran an analyze during a "quiet point" last night and for a few of my
large tables, I didn't get what I consider a reasonable sampling of
rows. When running with "verbose" enabled, it appeared that a maximum
of 240000 rows were being analyzed, including on tables exceeding 4-8mm
rows. My default_statistics_target = 80.

Shouldn't I be analyzing a larger percentage of these big tables?

What is the unit-of-measure used for default_statistics_target?

Thanks in advance,
AJ

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Heikki Linnakangas 2013-01-21 15:47:09 Re: Analyze and default_statistics_target
Previous Message rudi 2013-01-21 15:05:05 High CPU usage after partitioning