Re: [GENERAL] generating statistics

2005-03-16 Thread Michael Fuhr
On Wed, Mar 16, 2005 at 06:27:43PM +, vinita bansal wrote: > > Did you uncomment the settings in addition to setting them to true? > > Did you restart the database after making the configuration changes? > > Yes, I did. > FYI- I am using Postgres 8 Have you used SHOW to verify that the variabl

Re: [GENERAL] generating statistics

2005-03-16 Thread Tom Lane
"vinita bansal" <[EMAIL PROTECTED]> 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 postm

Re: [GENERAL] generating statistics

2005-03-16 Thread Michael Fuhr
On Wed, Mar 16, 2005 at 02:08:49PM +, vinita bansal wrote: > 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. Did you uncomment the settings in addition to setting them to true? > I

[GENERAL] generating statistics

2005-03-16 Thread vinita bansal
Hi, 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. I am trying to get a list of all used indices and referenced tables in the database for a particular run. According to the doc. the follow