X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 80F9D3A5644 for ; Wed, 1 Dec 2004 18:09:03 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 08291-07 for ; Wed, 1 Dec 2004 18:08:56 +0000 (GMT) Received: from axiontech.com (unknown [216.52.172.78]) by svr1.postgresql.org (Postfix) with SMTP id 393B03A5609 for ; Wed, 1 Dec 2004 18:08:56 +0000 (GMT) Received: (qmail 24592 invoked from network); 1 Dec 2004 18:09:03 -0000 Received: from pc-00161 (HELO yudie) (192.168.1.161) by mail.axiontech.com (192.168.1.6) with SMTP; 01 Dec 2004 18:09:03 -0000 Message-ID: <002201c4d7d0$9af23330$a101a8c0@home.axiontech.com> From: "Yudie" To: Subject: Found Large Files.. what objects are they? Date: Wed, 1 Dec 2004 12:07:20 -0600 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001F_01C4D79E.4F249A60" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.001 tagged_above=0 required=5 tests=HTML_MESSAGE X-Spam-Level: X-Archive-Number: 200412/5 X-Sequence-Number: 19625 This is a multi-part message in MIME format. ------=_NextPart_000_001F_01C4D79E.4F249A60 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I found bunch of large files (more than 1 gb) in one of database = directory. The files looks like this: 69233123 69233123.1 69233123.2 69233123.3 69233123.4 ...and so on. These large files very delay the dumping process.=20 Anyone know what it could be & how to delete the object related? How to = find a table by oid? Thanks=20 Yudie ------=_NextPart_000_001F_01C4D79E.4F249A60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I found bunch of large files (more than = 1 gb) in=20 one of database directory.
The files looks like this:
69233123
69233123.1
69233123.2
69233123.3
69233123.4
...and so=20 on.
 
These large files very delay the = dumping=20 process.
Anyone know what it could be & how = to delete=20 the object related? How to find a table by oid?
 
Thanks
 
Yudie
 
------=_NextPart_000_001F_01C4D79E.4F249A60--