Re: Disable vacuuming to provide data history

On 2/24/23 22:06, Corey Huinker wrote:
> On Thu, Feb 23, 2023 at 6:04 AM <marekmosiewicz@gmail.com> wrote:
> 
>   [1] some implementations don't use null, they use an end-timestamp set to
> a date implausibly far in the future ( 3999-12-31 for example ),

The specification is, "At any point in time, all rows that have their 
system-time period end column set to the highest value supported by the 
data type of that column are known as current system rows; all other 
rows are known as historical system rows."

I would like to see us use 'infinity' for this.

The main design blocker for me is how to handle dump/restore.  The 
standard does not bother thinking about that.
-- 
Vik Fearing