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.
Date: Wed, 29 Jan 2014 17:03:16 -0500
Message-ID: <8188.1391032996@sss.pgh.pa.us> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: tgl@sss.pgh.pa.us, petertblair@gmail.com
Subject: Re: Select hangs and there are lots of files in table and index directories.
In-Reply-To: <8188.1391032996@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox