Re: Large Files?

"Andrew Crouch" <s4011726@student.uq.edu.au> writes:
> -rw-------  1 postgres  dbadmin  122880 Oct 18 13:28 1269   <-- What is this
> file

pg_log, as you could find out with an inquiry against pg_class:

test71=# select relname from pg_class where relfilenode = 1269;
 relname
---------
 pg_log
(1 row)

test71=#

No, you can't delete it or shorten it, except by dump/initdb/reload.

7.2 will have a better approach to pg_log maintenance ...

            regards, tom lane