From: Tom Lane <tgl@sss.pgh.pa.us>
To: "David G. Johnston" <david.g.johnston@gmail.com>
cc: Stepan Neretin <sncfmgg@gmail.com>,
        "pgsql-admin@lists.postgresql.org" <pgsql-admin@lists.postgresql.org>
Subject: Re: SubTablespaces(Recursive) expected behaviour?
In-reply-to: 
 <CAKFQuwaCugbGWf35=TGJJqbSybjfD8DW2PWcZva1grAN1kv+Ow@mail.gmail.com>
References: 
 <CAN-sa+COZ3g6QrQKE_BaVTvTXa8WjMYdJPQZXR6oj3z9NJYMZQ@mail.gmail.com>
 <CAKFQuwazpwNRG4XJYGzzzrCwfYXMFrJAwijW3HMxv63Medf0fQ@mail.gmail.com>
 <CAN-sa+B4o_Jpimxfa09SmBZQTpjdRGjtvV=-ip=WRGEikAB5Zg@mail.gmail.com>
 <CAKFQuwaCugbGWf35=TGJJqbSybjfD8DW2PWcZva1grAN1kv+Ow@mail.gmail.com>
Comments: In-reply-to "David G. Johnston" <david.g.johnston@gmail.com>
	message dated "Sun, 28 Jul 2024 09:05:14 -0700"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <2253442.1722183010.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Sun, 28 Jul 2024 12:10:10 -0400
Message-ID: <2253443.1722183010@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/2253443.1722183010%40sss.pgh.pa.us>
Precedence: bulk

"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Sunday, July 28, 2024, Stepan Neretin <sncfmgg@gmail.com> wrote:
>> Hi, David. I have read this page several times and have not answered my
>> question. I'm probably not paying attention. Can you, I wanted to quote
>> what I'm missing out on

>  “The location must be an existing, empty directory that is owned by the
> PostgreSQL operating system user.”

Indeed, that doesn't directly answer the question, but I think the
implication is clear: we do not expect a tablespace directory to
contain anything except files that Postgres itself puts there.

I don't actually see the point of the described setup anyway.  There
is zero value that I can see in putting two tablespaces on the same
physical volume --- they won't provide any interesting separation.

			regards, tom lane