Large Files?

From: "Andrew Crouch" <s4011726(at)student(dot)uq(dot)edu(dot)au>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Large Files?
Date: 2001-10-18 03:36:00
Message-ID: NDBBKFCDMKJKLPCAHLPHOEGPCCAA.s4011726@student.uq.edu.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

[postres(at)kc131-161 /usr/local/opt/Postgres/data/global]# ls -la
total 170
drwx------ 2 postgres dbadmin 512 Oct 15 18:09 .
drwx------ 5 postgres dbadmin 512 Oct 15 18:00 ..
-rw------- 1 postgres dbadmin 8192 Oct 15 18:10 1260
-rw------- 1 postgres dbadmin 0 Oct 15 17:59 1261
-rw------- 1 postgres dbadmin 8192 Oct 18 13:00 1262
-rw------- 1 postgres dbadmin 0 Oct 15 17:59 1264
-rw------- 1 postgres dbadmin 122880 Oct 18 13:28 1269
-rw------- 1 postgres dbadmin 8192 Oct 15 17:59 17127
-rw------- 1 postgres dbadmin 8192 Oct 15 17:59 17130
-rw------- 1 postgres dbadmin 8192 Oct 18 13:28 pg_control
-rw------- 1 postgres dbadmin 0 Oct 15 18:09 pg_pwd
-rw------- 1 postgres dbadmin 0 Oct 15 18:08 pg_pwd.reload

-rw------- 1 postgres dbadmin 122880 Oct 18 13:28 1269 <-- What is this
file

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 ?

Regards
Andrew

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Flancer 2001-10-18 03:47:12 Break both? (Was To Postgres Devs : Wouldn't changing the select limit )
Previous Message Bruce Cota 2001-10-18 03:18:44 Getting OID after Insert