number of rows in analyze

From: Willy-Bas Loos <willybas(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: number of rows in analyze
Date: 2011-08-01 14:42:23
Message-ID: CAHnozTj5o7vJ3bJ_V0KUAA5dEopxpnE3akkew8pyurGy+cEf_Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi,

I'ver been wondering how to set the number of rows that are scanned by
analyze. (I want to increase it)
I couln't find it at first but when i read closer i found that is does:
"The largest statistics target among the columns being analyzed
determines the number of table rows sampled to prepare the
statistics."
(http://www.postgresql.org/docs/8.4/interactive/sql-analyze.html)

My question is *HOW* does it "detirmine the number of table rows
sampled" with the statistics target?
What is the formula behind it?

I am not familiar enough with the source code to figure that out
myself. sry about that.
Would be good to include in the docs if we find out.

Cheers,

WBL

--
"Patriotism is the conviction that your country is superior to all
others because you were born in it." -- George Bernard Shaw

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message ktm@rice.edu 2011-08-01 14:49:12 Re: number of rows in analyze
Previous Message Kevin Grittner 2011-07-29 15:53:40 Re: snapshot backup with WAL files

Browse pgsql-general by date

  From Date Subject
Next Message ktm@rice.edu 2011-08-01 14:49:12 Re: number of rows in analyze
Previous Message Raymond O'Donnell 2011-08-01 14:41:24 Re: Database backup to network folder