Re: Rollback in Postgres - Mailing list pgsql-sql

From Kaare Rasmussen
Subject Re: Rollback in Postgres
Date
Msg-id 200807142159.02451.kaare@jasonic.dk
Whole thread Raw
In response to Re: Rollback in Postgres  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Responses Re: Rollback in Postgres  ("Richard Broersma" <richard.broersma@gmail.com>)
Re: Rollback in Postgres  (Alvaro Herrera <alvherre@commandprompt.com>)
Re: Rollback in Postgres  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-sql
> I just lost a months worth of stats data myself, so join the club.  It
> wasn't critical data, but it would have been nice to have kept
> around...

I also think there could be a TODO item in it. If vacuum instead of removing 
items, somehow stashed them away in a storage limited archive it would be 
possible to do a SELECT...AS OF TIMESTAMP.

The idea is of course to be able to retrieve rows that really are deleted, but 
are still on disk as non-vacuumed or vacuumed and not removed completely. And 
it would also take a 2. stage vacuumer to keep the storage within its limits.

I don't say it's an important feature, but it would come in handy for people 
who really really need it. And perhaps a developer wouldn't mind scratching 
this itch some time in the future.

-- 

Med venlig hilsen
Kaare Rasmussen, Jasonic

Jasonic                 Telefon: +45 3816 2582
Nordre Fasanvej 12
2000 Frederiksberg      Email: kaare@jasonic.dk


pgsql-sql by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Rollback in Postgres
Next
From: "Richard Broersma"
Date:
Subject: Re: Rollback in Postgres