Home > mailing lists

Redundant database objects. - Mailing list pgsql-general

From	Andrew Bartley
Subject	Redundant database objects.
Date	July 12, 2010 21:47:31
Msg-id	AANLkTin-RZBtMJwnpoedhCDS3Smrb8f8bHoeQapwHsxF@mail.gmail.com Whole thread Raw
Responses	Re: Redundant database objects. (Joe Conway <mail@joeconway.com>) Re: Redundant database objects. (Alexander Pyhalov <alp@rsu.ru>)
List	pgsql-general

Hi all,

Our project has been running for 10 years now.

We have a large number of orphaned or redundant tables, views, and functions, due to many years of inadequate source management.

We are running " PostgreSQL 8.3.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.3.real (Debian 4.3.2-1.1) 4.3.2 "

Is there an effective way to identify these objects using the stats tables? Something like a last accessed/used or some such column?

Any suggestions welcomed.

Thanks

Andrew Bartley

Aimstats Pty Ltd

From: Thomas Kellerer
Date: 12 July 2010, 21:30:04
Subject: Testing 9.0beta3 and pg_upgrade

From: Joe Conway
Date: 12 July 2010, 22:47:07
Subject: Re: Redundant database objects.