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
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 |