Re: Large Files?

"Andrew Crouch" <s4011726@student.uq.edu.au> writes:

> Im running a fairly heavy database application, this file grew in size to
>
> -rw------- 1 postgres dbadmin 961904640 Oct 15 16:18 1269
>
> over a period of 2-3 months?
>
>
> Failing everything, I backed up the database, upgraded postgres and reloaded
> the database only to see this file popup again.  Can i safely delete this
> file? What is it? Do i need it ?

No, you can't delete it.  It's probably a table in your database.  Are
you running VACUUM periodically?  If not, try doing so and you should
see those files shrink.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863