Re: Weeding out unused user created database objects, could I use pg_catalog? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Weeding out unused user created database objects, could I use pg_catalog?
Date
Msg-id 4B75A900.2070601@archonet.com
Whole thread Raw
In response to Re: Weeding out unused user created database objects, could I use pg_catalog?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On 12/02/10 18:13, Tom Lane wrote:
> Richard Huxton<dev@archonet.com>  writes:
>
>> The best you can do is to turn on statement logging, parse the logs to
>> see what objects are used and then keep those and their dependencies.
>
> Or: remove some objects, run your test case, see if it succeeds.
> Repeat as needed.

If you've lost track of which database objects are in use, I'm not sure
your test suite is such a reliable indicator.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Bill Moran
Date:
Subject: Re: db size and VACUUM ANALYZE
Next
From: Marcin Krol
Date:
Subject: Re: db size and VACUUM ANALYZE