Yes I did restart the database after making these changes but still there is no data in pg_statio_user_tables view.
-----Original Message----- From: Scott Marlowe [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 15, 2008 7:20 AM To: Bhella Paramjeet-PFCW67 Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Pg_statio_user_tables view does not get populated On Jan 14, 2008 6:43 PM, Bhella Paramjeet-PFCW67 <[EMAIL PROTECTED]> wrote: > I have installed postgres 8.2.4 in my development environment. I have > the stats_command_string, stats_start_collector, stats_block_level, > stats_row_level options turned on in postgresql.conf file but still > the pg_statio_user_tables view does not get populated. Is there any > other option I need to enable? Please advice. Have you restarted postgresql since making those changes? ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
