schema Cleanning

From: salah jubeh <s_jubeh(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: schema Cleanning
Date: 2011-02-21 15:53:41
Message-ID: 299328.3682.qm@web52703.mail.re2.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello,

I am trying to drop deprecated tables, views, procedures from an existing
database, I am checking the pg_stat_user_tables view to check if the tables are
accessed recently also to check live tuples. For deprecated views and
procedures, I am wondering How can I do that, for example suppose the table is
used and there is a view defined using this table but no one is using it. Is
there is away to check the views statistics.

Regards

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Geoffrey Myers 2011-02-21 18:53:58 Re: disable triggers using psql
Previous Message Norberto Delle 2011-02-21 14:39:30 Continuous recovery stopping