...@yahoo.com
Sent: Wed, February 23, 2011 11:57:01 PM
Subject: RE: [GENERAL] schema Cleanning
I do not know what your criteria is for dropping things. But I would be very
sure that something is no longer used. For example, some tables are not used
but once a quarter or once a year. And the same is
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
From: salah jubeh
To: pgsql-general@postgresql.org
Sent: Mon, February 21, 2011 4:53:41 PM
Subject: [GENERAL] schema Cleanning
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
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 suppos
