| From: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
|---|---|
| To: | Dirk Krautschick <Dirk(dot)Krautschick(at)trivadis(dot)com> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: Is there something similar like flashback query from Oracle planned for PostgreSQL |
| Date: | 2021-06-23 23:37:54 |
| Message-ID: | CA+hUKGKF3mdx+CYAfW-WqTbsk-N4y12N0xqiVL201dRxBu0ubA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Jun 24, 2021 at 6:54 AM Dirk Krautschick
<Dirk(dot)Krautschick(at)trivadis(dot)com> wrote:
> Is there something planned to get a behaviour like Oracle's flashback query based on the old values
> before deleted by vacuum?
>
> So a feature to recreate old versions of rows if still there?
>
> Or are there any related extensions or tools doing this?
There are some things like pg_dirtyread and probably more. You might
be interested in some of the references in this thread:
As for the SQL standard's approach to this, there are some active
-hackers threads on that with patches in development... look for
"temporal tables" and "system versioned".
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2021-06-23 23:39:16 | Re: Partitioned Table Index Column Order |
| Previous Message | Tomas Vondra | 2021-06-23 22:56:04 | Re: How to hash a large amount of data within Postgres? |