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

[Condor-users] How to shrink quill database?


Our quill database has ballooned recently to the point where it takes
over 75% of its partition. I've had to disable the quill & dbmsd daemons
to allow condor to continue to run.

Is there a way, either through Condor or Postgres, that we can reduce
this size? Vacuuming/emptying specific tables leaps to mind (a whole DB
vacuum exceeds our current settings), but I'm not sure if this is safe.
Also, I can't find a sql folder in the release directory to try 'psql -h
hostname -d databasename < pgsql_dropddl.sql' mentioned on the wiki.

I don't mind losing it all & starting from scratch, but I'm a postgres
novice & don't want to cripple it completely.


The information contained in the EMail and any attachments is
confidential and intended solely and for the attention and use of
the named addressee(s). It may not be disclosed to any other person
without the express authority of the HPA, or the intended
recipient, or both. If you are not the intended recipient, you must
not disclose, copy, distribute or retain this message or any part
of it. This footnote also confirms that this EMail has been swept
for computer viruses, but please re-sweep any attachments before
opening or saving. HTTP://www.HPA.org.uk