Message-ID: <16220683f58d6ce349aee3511d4a6328d03daa82.camel@cybertec.at>
Subject: Re: Tablespace size in TB
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Jan Karremans <karremans.ja@gmail.com>
Cc: masheed ullah <masheedullah@gmail.com>, Thiemo Kellner
	 <thiemo@gelassene-pferde.biz>, pgsql-general@lists.postgresql.org
Date: Sun, 03 May 2026 18:59:41 +0200
In-Reply-To: <86590390-F0A6-448A-985A-AA7CCC5D9C16@gmail.com>
References: 
	<CAHr8x_tgJh2vb8gyq-kmrbtKstaAYUpmWC3+umwGXhOZYeMxOQ@mail.gmail.com>
	 <CDB30DC3-C4C6-4437-93E8-6440E0B03782@gmail.com>
	 <ba2496302b3d6ae301b90f442bd22dc63cd285af.camel@cybertec.at>
	 <86590390-F0A6-448A-985A-AA7CCC5D9C16@gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.58.3 (3.58.3-1.fc43) 
MIME-Version: 1.0
Archived-At: <https://www.postgresql.org/message-id/16220683f58d6ce349aee3511d4a6328d03daa82.camel%40cybertec.at>
Precedence: bulk

On Sun, 2026-05-03 at 14:25 +0200, Jan Karremans wrote:
>=20
> > On 3 May 2026, at 14:21, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> >=20
> > On Sun, 2026-05-03 at 14:10 +0200, Jan Karremans wrote:
> > > Contrary to Oracle, a table space in PostgreSQL is a directory. And n=
ot a logical abstraction.
> > > Moving tables from one table space to another becomes so much easier =
by that.
> >=20
> > I am confused.  Yes, if you have more than a single (default) tablespac=
e,
> > moving tables between tablespaces becomes possible and hence easier.
> > But why would you want to move tables between tablespaces in the first =
place?
>
> My thinking would be to have the different directories on different tiers=
 of storage.

I see.  That can indeed improve the throughput, but you don't need tablespa=
ces for
that: it would be simpler to define a striped logical volume.

Yours,
Laurenz Albe