Skip site navigation (1) Skip section navigation (2)

Re: thousand unrelated data files in pg_default tablespace

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: thousand unrelated data files in pg_default tablespace
Date: 2010-08-31 15:09:57
Message-ID: 3082.1283267397@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> writes:
> there is a dump from 8KB files

Well, those certainly look like tables/indexes not temp files.
So we can rule out one theory.

You're *certain* these aren't referenced from pg_class.relfilenode
of any of the databases in the server?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Dave PageDate: 2010-08-31 15:09:58
Subject: Re: [BUGS] BUG #5305: Postgres service stops when closing Windows session
Previous:From: Cristian BittelDate: 2010-08-31 14:40:33
Subject: Re: [BUGS] BUG #5305: Postgres service stops when closing Windows session

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group