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
>
--
С уважением,
Александр Пыхалов,
системный администратор ЮГИНФО ЮФУ.