Re: Redundant database objects.

Thanks Alexander,

Wish i had thought of that.

I still need some way of finding redundant functions

Thanks again

Andrew

On 13 July 2010 15:38, Alexander Pyhalov <alp(at)rsu(dot)ru> wrote:

> Hello.
> When we moved old projects from postgresql 7.x to 8.4, I just looked at
> modification time for files in base/<dboid>/<toid> . So, I could determine,
> that some databases were inactive (precisely,not updated) for about a year
> and move them to archive...
>
> Andrew Bartley wrote:
>
> 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
>>
>>
>
> --
> С уважением,
> Александр Пыхалов,
> системный администратор ЮГИНФО ЮФУ.
>
>