Re: Rollback in Postgres

Поиск
Список
Период
Сортировка
От Kaare Rasmussen
Тема Re: Rollback in Postgres
Дата
Msg-id 200807142159.02451.kaare@jasonic.dk
обсуждение исходный текст
Ответ на Re: Rollback in Postgres  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: "Scott Marlowe"
Дата:
Сообщение: Re: Rollback in Postgres
Следующее
От: "Richard Broersma"
Дата:
Сообщение: Re: Rollback in Postgres