Re: Large and Growing Group of Files

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: John Iliffe <john(dot)iliffe(at)iliffe(dot)ca>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Large and Growing Group of Files
Date: 2017-03-13 23:20:50
Message-ID: CAKFQuwb-8_+K6SrxYVP3ZaX6SR4-C-8554B+G1kCRQydRgQ=gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Mar 13, 2017 at 4:12 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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

​In particular note the paragraph whose leading sentence is:

"​Tablespaces make the scenario more complicated."

What you showed up was the "far end" of a custom tablespace link.

David J.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message John Iliffe 2017-03-13 23:37:56 Re: Large and Growing Group of Files
Previous Message Tom Lane 2017-03-13 23:12:10 Re: Large and Growing Group of Files