"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 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 ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match