Search Postgresql Archives

Re: Weeding out unused user created database objects, could I use pg_catalog?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 12/02/10 18:13, Tom Lane wrote:
Richard Huxton<dev@xxxxxxxxxxxx>  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

--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux