Re: [GENERAL] Large and Growing Group of Files

2017-03-13 Thread John Iliffe
On Monday 13 March 2017 19:12:10 Tom Lane wrote: > John Iliffe 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 so

Re: [GENERAL] Large and Growing Group of Files

2017-03-13 Thread David G. Johnston
On Mon, Mar 13, 2017 at 4:12 PM, Tom Lane wrote: > John Iliffe 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

Re: [GENERAL] Large and Growing Group of Files

2017-03-13 Thread Tom Lane
John Iliffe 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/stor

[GENERAL] Large and Growing Group of Files

2017-03-13 Thread John Iliffe
Can anybody tell what these files are and what they do, and more importantly if they are needed? This database has been in use since about 2012 on PostgreSQL 9.2 and is quite active. (both read and insert/change). There seems to be one group of these files a week, total 316 files as of today