public inbox for pgsql-general@postgresql.org  

help / color / mirror / Atom feed

From: Jan Karremans <karremans.ja@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: masheed ullah <masheedullah@gmail.com>
Cc: Thiemo Kellner <thiemo@gelassene-pferde.biz>
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Tablespace size in TB
Date: Sun, 3 May 2026 14:25:26 +0200
Message-ID: <86590390-F0A6-448A-985A-AA7CCC5D9C16@gmail.com> (raw)
In-Reply-To: <ba2496302b3d6ae301b90f442bd22dc63cd285af.camel@cybertec.at>
References: <CAHr8x_tgJh2vb8gyq-kmrbtKstaAYUpmWC3+umwGXhOZYeMxOQ@mail.gmail.com>
	<CDB30DC3-C4C6-4437-93E8-6440E0B03782@gmail.com>
	<ba2496302b3d6ae301b90f442bd22dc63cd285af.camel@cybertec.at>

My thinking would be to have the different directories on different tiers of storage.

Cheers,
Jan

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

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-general@postgresql.org
  Cc: karremans.ja@gmail.com, laurenz.albe@cybertec.at, masheedullah@gmail.com, thiemo@gelassene-pferde.biz, pgsql-general@lists.postgresql.org
  Subject: Re: Tablespace size in TB
  In-Reply-To: <86590390-F0A6-448A-985A-AA7CCC5D9C16@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox