Search Postgresql Archives

Re: Redundant database objects.

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

 



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@xxxxxx> 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



--
�����
���� ���
�������������� �.



[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