Re: schema Cleanning

Le 23/02/2011 09:10, salah jubeh a écrit :
> [...]
> This is a simple way to check if there is no activity on the table,
>
> SELECT relname,seq_tup_read,idx_tup_fetch  FROM pg_stat_user_tables
> WHERE (idx_tup_fetch + seq_tup_read)= 0;
>
>
> Is there is any way to make similar checks on views
>

No, there's no stats on views.


--
Guillaume
 http://www.postgresql.fr
 http://dalibo.com