From: Tom Lane <tgl@sss.pgh.pa.us>
To: Peter Blair <petertblair@gmail.com>
cc: pgsql-performance@postgresql.org
Subject: Re: Select hangs and there are lots of files in table and index
 directories.
In-reply-to: 
 <CAJ9LHMVA_aKx9Bz1rYn6NDEG9zggvSTbDf9QPAowd4ehsVFoMA@mail.gmail.com>
References: 
 <CAJ9LHMVonzD1rjGoDRawC6tccCh3rVULvz02-W45oUFaziykdQ@mail.gmail.com>
 <27362.1390869815@sss.pgh.pa.us>
 <CAJ9LHMV_QAvjTF1-4185WSA7aG1ZsoJyjiXQ1-eEihxAjtOsOQ@mail.gmail.com>
 <CAJ9LHMVA_aKx9Bz1rYn6NDEG9zggvSTbDf9QPAowd4ehsVFoMA@mail.gmail.com>
Comments: In-reply-to Peter Blair <petertblair@gmail.com>
 message dated "Wed, 29 Jan 2014 14:12:33 -0500"
Date: Wed, 29 Jan 2014 17:03:16 -0500
Message-ID: <8188.1391032996@sss.pgh.pa.us>
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Peter Blair <petertblair@gmail.com> writes:
> One other problem with this case, those 900K worth of files in each of the
> table and index directories (1.8M total files) are still hanging around.

Hm ... if left to its own devices, I think the session that created them
should have deleted them, assuming you did a normal query cancel on it.
Maybe you did kill -9?

> Just a guess, but do I shutdown the database, and delete any file not
> listed in pg_class?

For starters, try just stopping and starting the database; I think there
might be logic to remove orphaned files during postmaster startup.

If that doesn't work, you can get rid of any numeric-named files that
match no value in pg_class.relfilenode of their database.

			regards, tom lane


-- 
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance