public inbox for [email protected]  

help / color / mirror / Atom feed

From: [email protected]
To: PostgreSQL General <[email protected]>
Subject: Re: Plans for partitioning of inheriting tables
Date: Fri, 01 Nov 2024 20:14:08 +0100
Message-ID: <20241101201408.Horde.O-JA4FN6beZ7-GZi4ySiKnQ@webmail.gelassene-pferde.biz> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
	<20241101094106.Horde.TwPSs9YUgJ5v-_M-4ltwoeh@webmail.gelassene-pferde.biz>
	<[email protected]>
	<20241101182110.Horde.P_w6KptTjJNeM1X9Asg5bE3@webmail.gelassene-pferde.biz>
	<[email protected]>


Adrian Klaver <[email protected]> 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.

view thread (13+ messages)  latest in thread

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: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Plans for partitioning of inheriting tables
  In-Reply-To: <20241101201408.Horde.O-JA4FN6beZ7-GZi4ySiKnQ@webmail.gelassene-pferde.biz>

* 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