Received-SPF: pass (ha01s018.org-dns.com: connection is authenticated)
Date: Fri, 01 Nov 2024 20:14:08 +0100
Message-ID: 
 <20241101201408.Horde.O-JA4FN6beZ7-GZi4ySiKnQ@webmail.gelassene-pferde.biz>
From: thiemo@gelassene-pferde.biz
To: PostgreSQL General <pgsql-general@lists.postgresql.org>
Subject: Re: Plans for partitioning of inheriting tables
References: <ea963edb-5437-4de6-bd2c-97c141a391b8@gelassene-pferde.biz>
 <5757acdc-39ed-4642-a449-26e47b1bcf95@gelassene-pferde.biz>
 <d9d6a2f4-379b-45f3-9005-ab047625c1a4@aklaver.com>
 <20241101094106.Horde.TwPSs9YUgJ5v-_M-4ltwoeh@webmail.gelassene-pferde.biz>
 <14c1eb8c-a853-43b3-a1ea-b105bfd6c99b@aklaver.com>
 <20241101182110.Horde.P_w6KptTjJNeM1X9Asg5bE3@webmail.gelassene-pferde.biz>
 <6bc57377-52e1-496a-b9d6-4cd9dc84d92e@aklaver.com>
In-Reply-To: <6bc57377-52e1-496a-b9d6-4cd9dc84d92e@aklaver.com>
Accept-Language: de
Content-Type: text/plain; charset=utf-8; format=flowed; DelSp=Yes
MIME-Version: 1.0
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/20241101201408.Horde.O-JA4FN6beZ7-GZi4ySiKnQ%40webmail.gelassene-pferde.biz>
Precedence: bulk


Adrian Klaver <adrian.klaver@aklaver.com> escribió:

> Even if there where plans, any changes would happen in the future  
> and would not be help the now problem.

Yes and no. I can live without the partitioning, as I do not intend to  
load data from more than one source. Other might. But until others  
want to load data from different sources, a comment in the source  
might do that partitioning of inheriting tables will be supported in  
the future. But, that is an academic point now.

> That is contradicted by your statement below:
>
> Either performance is important or it is not.

Not quite. If the performance penalty by suboptimal choice in  
partitioning does not matter in the current project because the  
raster/bytea stuff does affect performance much more, it does not mean  
that I cannot work on other project where it can matter. And even if  
the latter is not the case, I can be just curious about it.

> If TILE is referring to the same thing you are dealing with in  
> related question on psycopg list then you are talking about bytea  
> storage. You should take a look at:
>
> https://www.postgresql.org/docs/current/storage-toast.html

Indeed, it does. Thanks for the hint.