Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated)
Date: Sun, 3 May 2026 21:38:59 +0200
From: Thiemo Kellner <thiemo@gelassene-pferde.biz>
To: pgsql-general <pgsql-general@lists.postgresql.org>
Message-ID: <cf577ffe-2d88-4647-a873-5301fbb28ff7@gelassene-pferde.biz>
In-Reply-To: 
 <CAHr8x_sCFOpufrmTPBF2nOFMyJfWG6EPHMfN+UOiKdfLF_kVdA@mail.gmail.com>
References: 
 <CAHr8x_tgJh2vb8gyq-kmrbtKstaAYUpmWC3+umwGXhOZYeMxOQ@mail.gmail.com>
 <CDB30DC3-C4C6-4437-93E8-6440E0B03782@gmail.com>
 <ba2496302b3d6ae301b90f442bd22dc63cd285af.camel@cybertec.at>
 <CAHr8x_sCFOpufrmTPBF2nOFMyJfWG6EPHMfN+UOiKdfLF_kVdA@mail.gmail.com>
Subject: Re: Tablespace size in TB
Content-Type: multipart/alternative;
	boundary="----=_Part_2_44620553.1777837139679"
Archived-At: <https://www.postgresql.org/message-id/cf577ffe-2d88-4647-a873-5301fbb28ff7%40gelassene-pferde.biz>
Precedence: bulk

------=_Part_2_44620553.1777837139679
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

Even with Oracle you need to know the architecture of your storage to decid=
e whether you can expect performance improvements. If you happen to have so=
me kind of NAS, you partitions for the different table spaces might reside =
on the very same hardware and you probably gain naught.

03.05.2026 14:27:01 masheed ullah <masheedullah@gmail.com>:

> Just to check like Oracle, parallelism=C2=A0works well with multiple tabl=
espaces.
> Moving tables/ indexes to multiple tablespaces to use the parallelism to =
boost the backup speed. With a single tablespace, parallelism will not work=
.
>=20
> On Sun, May 3, 2026 at 3:21=E2=80=AFPM Laurenz Albe <laurenz.albe@cyberte=
c.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.
>>=20
>> I am confused.=C2=A0 Yes, if you have more than a single (default) table=
space,
>> moving tables between tablespaces becomes possible and hence easier.
>> But why would you want to move tables between tablespaces in the first p=
lace?
>>=20
>> Yours,
>> Laurenz Albe
>=20
>=20
>=20

------=_Part_2_44620553.1777837139679
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: quoted-printable

<html>
 <head>
  <meta name=3D"viewport" content=3D"width=3Ddevice-width, initial-scale=3D=
1.0">
 </head>
 <body>
  <span dir=3D"ltr" style=3D"margin-top:0; margin-bottom:0;">Even with Orac=
le you need to know the architecture of your storage to decide whether you =
can expect performance improvements. If you happen to have some kind of NAS=
, you partitions for the different table spaces might reside on the very sa=
me hardware and you probably gain naught.</span>
  <br>
  <div class=3D"fairemail_quote">
   <div dir=3D"ltr">
    <p>03.05.2026 14:27:01 masheed ullah &lt;masheedullah@gmail.com&gt;:</p=
>
   </div>
   <blockquote style=3D"margin:0;border-left:3px solid #ccc; padding-left:1=
0px;">
    <div dir=3D"ltr">
     <div dir=3D"ltr">
      Just to check like Oracle, parallelism&nbsp;works well with multiple =
tablespaces.=20
      <br>
       Moving tables/ indexes to multiple tablespaces to use the parallelis=
m to boost the backup speed. With a single tablespace, parallelism will not=
 work.
     </div>
     <br>
     <div class=3D"gmail_quote gmail_quote_container">
      <div dir=3D"ltr" class=3D"gmail_attr">
       On Sun, May 3, 2026 at 3:21=E2=80=AFPM Laurenz Albe &lt;<a href=3D"m=
ailto:laurenz.albe@cybertec.at">laurenz.albe@cybertec.at</a>&gt; wrote:=20
       <br>
      </div>
      <blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;b=
order-left:1px solid rgb(204,204,204);padding-left:1ex;">
       On Sun, 2026-05-03 at 14:10 +0200, Jan Karremans wrote:=20
       <br>
        &gt; Contrary to Oracle, a table space in PostgreSQL is a directory=
. And not a logical abstraction.=20
       <br>
        &gt; Moving tables from one table space to another becomes so much =
easier by that.=20
       <br>
       <br>
        I am confused.&nbsp; Yes, if you have more than a single (default) =
tablespace,=20
       <br>
        moving tables between tablespaces becomes possible and hence easier=
.=20
       <br>
        But why would you want to move tables between tablespaces in the fi=
rst place?=20
       <br>
       <br>
        Yours,=20
       <br>
        Laurenz Albe=20
       <br>
      </blockquote>
     </div>
     <div>
      <br clear=3D"all">
     </div>
     <div>
      <br>
     </div>
     <div dir=3D"ltr" class=3D"gmail_signature">
      <div dir=3D"ltr">
       <div>
        <br>
       </div>
      </div>
     </div>
    </div>
   </blockquote>
  </div>
 </body>
</html>
------=_Part_2_44620553.1777837139679--