Re: Large Files?

"Andrew Crouch" <s4011726(at)student(dot)uq(dot)edu(dot)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