Re: generating statistics

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "vinita bansal" <sagivini(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: generating statistics
Date: 2005-03-16 15:30:54
Message-ID: 6155.1110987054@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"vinita bansal" <sagivini(at)hotmail(dot)com> writes:
> I have set the following variables in postgresql.conf to true:
> stats_start_collector,stats_command_string, stats_row_level,
> stats_reset_on_server_start.

Is the statistics collector actually starting? Look in "ps auxww"
output to see if the postmaster has a pair of child processes that claim
to be the stats collector and stats buffer processes.

If not, the postmaster log should have some info about the problem.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2005-03-16 15:31:59 Re: 2 questions about types
Previous Message Miroslav Šulc 2005-03-16 15:28:11 Re: psql file restore - problem with encoding