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:scott.marlowe@gmail.com]
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 <PBhella@motorola.com>
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?