Richard Huxton <dev@xxxxxxxxxxxx> writes: > On 12/02/10 15:10, Allan Kamau wrote: >> Therefore I am looking for a solution that contains >> "last-accessed-time" data for these objects, especially for the >> functions and maybe the triggers. > Ah, sorry - misunderstood. There's not any timestamp kept. As you can > imagine, it would be a cost you'd have to pay every time you accessed an > object. > 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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
