Re: Large Files? - Mailing list pgsql-general

From Doug McNaught
Subject Re: Large Files?
Date
Msg-id m3elo1oxnl.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to Large Files?  ("Andrew Crouch" <s4011726@student.uq.edu.au>)
List pgsql-general
"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

pgsql-general by date:

Previous
From: qk22@gmx.co.uk (qk22)
Date:
Subject: Can not input large text data
Next
From: Alan
Date:
Subject: newbie authentication/automated backup (pg_dumpall) questions