split_chunk()

Split a large chunk at a specific point in time.

Split a large at a specific point in time. If you do not specify the timestamp to split at, the is split equally.

Samples

• Split a chunk at a specific time:

  CALL split_chunk('chunk_1', split_at => '2025-03-01 00:00');
  

• Split a in two:

  For example, If the duration is, 24 hours, the following command splits chunk_1 into two s of 12 hours each.

  CALL split_chunk('chunk_1');
  

Arguments

Name	Type	Default	Required	Description
chunk	REGCLASS	-	✔	Name of the to split.
split_at	TIMESTAMPTZ	-	✖	Timestamp to split the at.

Returns

This function returns void.