Hi,
I have a table that is capturing what is, basically, time series data. We
use identity column as primary key.
I'm considering the potential to partition it by the "source" of the time
series (100s .. 1000s of sources) as often (but not always) use of this
table is to get the time series for on
On Mon, 19 Feb 2024 at 14:23, David Rowley wrote:
>
> On Mon, 19 Feb 2024 at 16:32, Darryl Green wrote:
> > 2) It would be nice to be able to specify the id as pk on the table
being partitioned (as it was in the non-partitioned definition of the
table) once to document and enfo
On Mon, 19 Feb 2024 at 17:31, Peter Eisentraut wrote:
>
> On 19.02.24 04:32, Darryl Green wrote:
> > I note that in Postgresql 16 identity column handling in partitioned
> > tables has been aligned to the view that the partitioned table as a
> > whole is a single r
