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 A7D6F3A49EC
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  1 Dec 2004 22:53:30 +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 90188-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed,  1 Dec 2004 22:53:19 +0000 (GMT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by svr1.postgresql.org (Postfix) with ESMTP id 86E0C3A5466
	for <pgsql-sql@postgresql.org>; Wed,  1 Dec 2004 22:53:19 +0000 (GMT)
Received: from news.hub.org (news.hub.org [200.46.204.72])
	by news.hub.org (8.13.1/8.13.1) with ESMTP id iB1MrIrh095628
	for <pgsql-sql@postgresql.org>; Wed, 1 Dec 2004 22:53:18 GMT
	(envelope-from news@news.hub.org)
Received: (from news@localhost)
	by news.hub.org (8.13.1/8.13.1/Submit) id iB1Mo1Rw094688
	for pgsql-sql@postgresql.org; Wed, 1 Dec 2004 22:50:01 GMT
	(envelope-from news)
From: Christopher Browne <cbbrowne@acm.org>
X-Newsgroups: pgsql.sql
Subject: Re: Found Large Files.. what objects are they?
Date: Wed, 01 Dec 2004 17:46:45 -0500
Organization: cbbrowne Computing Inc
Lines: 39
Message-ID: <m3eki9skkq.fsf@knuth.knuth.cbbrowne.com>
References: <002201c4d7d0$9af23330$a101a8c0@home.axiontech.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
X-Complaints-To: usenet@news.hub.org
X-message-flag: Outlook is rather hackable, isn't it?
X-Home-Page: http://www.cbbrowne.com/info/
X-Affero: http://svcs.affero.net/rm.php?r=cbbrowne
User-Agent: Gnus/5.1006 (Gnus v5.10.6) XEmacs/21.4 (Security Through
 Obscurity,
	linux)
Cancel-Lock: sha1:1Kzb0MzkKRTtDQtSeI23ETuFCNU=
To: pgsql-sql@postgresql.org
X-Virus-Scanned: by amavisd-new at hub.org
X-Archive-Number: 200412/10
X-Sequence-Number: 19630

Centuries ago, Nostradamus foresaw when yudie@axiontech.com ("Yudie") would write:
> 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.
>
> Anyone know what it could be & how to delete the object related? How to find a table by oid?

The phenomenon you are seeing occurs when there is a table with a
great deal of data.

Look for the table via the query:

  select * from pg_class where oid = 69233123;

Presumably these files are for a table that contains multiple GB of
data.  Or they could be for an index on a very large table.

If the data in the table/index is useless to you, you might consider
dropping the table/index.
-- 
let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;;
http://www3.sympatico.ca/cbbrowne/wp.html
DO IT -- it's easier to get forgiveness than permission.