Re: Large and Growing Group of Files

From: John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Large and Growing Group of Files
Date: 2017-03-13 23:37:56
Message-ID: 201703131937.56763.john.iliffe@iliffe.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Monday 13 March 2017 19:12:10 Tom Lane wrote:
> John Iliffe <john(dot)iliffe(at)iliffe(dot)ca> writes:
> > Can anybody tell what these files are and what they do, and more
> > importantly if they are needed?
>
> They are database table files, and you will certainly be unhappy if you
> just manually rm them.
>
> You can read some theory here:
>
> https://www.postgresql.org/docs/9.2/static/storage.html
>
> and for help in identifying specific files you might like oid2name:
>
> https://www.postgresql.org/docs/9.2/static/oid2name.html
>
> although it's certainly possible to get the same results with manual
> queries on the system catalogs.
>
> regards, tom lane
Thanks Tom.

I was sure they weren't abandoned but the increasing number of them made me
wonder if I had a configuration issue.

John

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Michael Paquier 2017-03-14 02:19:00 Re: Recovery damaged dump file
Previous Message David G. Johnston 2017-03-13 23:20:50 Re: Large and Growing Group of Files