Following my very lengthy upgrade from 12.4.1 to 14.0.3 I'm now using a lot more disk than before. I have two questions around this - one of which I think has been asked before but I couldn't find any answers:
Having said that, I'm planning on migrating the install to a new server anyway (2012) so, another question(s) would be:
thanks for your help
the clean performance data script only deleted the contents of the tables from the files, it does not clean out the files them selves. The script does not remove files them self - and the vacum process only clean contents of files. Before you delete that folder / OID it would be good to know if any table(s) maps to those files.
is there a way to easily check for the mapping?
I think I've said this before but I'm moving the install to a new server as well so I might wait to see if these old tables get copied across or not before I proceed.
my BNA server down / unavailable for since time, but the proper way would be to export / import (or backup / restore) the database. Sorry, but until my DB is back, I cannot help with a command / gui to identify which files are activelty used in postgres or not.
to answer my own question - and for anyone interested - I've now moved the install of BNA to a new server and here are my findings: