Turn dead tuples into temporal data?

From: Jean Baro <jfbaro(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Turn dead tuples into temporal data?
Date: 2021-11-14 00:46:15
Message-ID: CA+fQeenohVgcU4KT3idCkrwFqcg5wULVKxeHK44kfQMpKTH5BA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hello there,

I am not a databse engineer but I always loved the beauty and
sophistication of RDBMSes.

I love PostgreSQL and its community and I have also followed Datomic (BI
temporal database) since its beginning.

Would it be possible,(within 1 or 2 releases of PostgreSQL), without having
to change many of other things that PostgreSQL already does pretty well, to
use the DEAD tuples as historical information for native BI-temporal
capability in PostgreSQL?

The main idea (without me knowing much about the internals of PostgreSQL)
is to keep the dead tuples as a mean to answer BITemporal queries...

If small changes can be done (maybe an ON/OFF Toggle) to enable this
behavior per table, it might even free the BITemporal enabled table from
needing Vaccum, at the expense of consuming MUCH more storage.

Specially for financial application BITemporality is an important feature,
and if that is "native" to a DB like PostgreSQL it would put PG ahead of
the game.

Sorry for the "dream" question here, I just want someone experienced to
explain to me why this is a terrible ideal in PostgreSQL.. só that I can
learn more!

Thanks.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Jean Baro 2021-11-14 01:06:24 Re: Phonetic representation LENGHT for DMETAPHONE, is there a way to make it longer?
Previous Message David G. Johnston 2021-11-12 20:57:39 Re: Regclass what does reg mean